How can I access mysql on lamp droplet?

February 25, 2014 2.3k views
js276751
By:
js276751
I've ssh onto server. Then tried to use mysqladmin -u root -p 'password' to access mysql, but that doesn't work. How can I add a user to mysql? which command should I use?
Log In to Comment
4 Answers
themadman300 February 25, 2014
Use
mysql -u root -p
Enter your password

CREATE USER 'username'@'host' IDENTIFIED BY 'password';
Reply
js276751 February 25, 2014
@themadman300
I tried it, but here is what I get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Reply
themadman300 February 25, 2014
Did you restart MySQL and set a password yet? Restart the mysql service and set a pass for MYSQL root, use that pass for mysql.
Reply
js276751 February 25, 2014
@themadman300
I didn't install mysql myself. I use the Lamp image when I create the Droplet.
After I login to server, actually I can't do anything on Mysql.

Especially, I was told this every time I logged in:
-------------------
Please be sure to change your root MySQL password; current MySQL password is "password"

You can change the MySQL password with the following command:

mysqladmin -u root -p'password' password newpassword
-------------------

But I still can not access Mysql using the command it gives me: mysqladmin -u root -p'password' password newpassword

Do you have any idea?
Reply
Have another answer? Share your knowledge.