paulmellors.net | Paul Mellors

After posting earlier about having problems with Ubuntu Server and mysql I was given a little lesson in command line mysql by Philip Newborough [thanks]

I think i'll pass it on. My problem was creating mysql users/databases via phpmyadin which left me unable to import my .sql files. Here's what i had to do.

1, mysql --user="root" --password="your_root_password" - This connects to the mysql server as root

2, CREATE USER 'new_username'@'localhost' IDENTIFIED BY 'password_for_new_username';

3, GRANT ALL ON *.* TO 'new_username'@'localhost';

4, create database databasename;

I could then import my .sql files using -

mysql -u<username> -p database < databasefile.sql

If you're reading this post then you're reading it on my shiny new install of Ubuntu Heron Server 8.04 LTS.

This entry was posted on Friday, May 9th, 2008 at 7:12 pm and is filed under General. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.