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.
Related posts: