MySQL: tips

List Users

select * from mysql.user;

Update password

UPDATE mysql.user SET Password=PASSWORD(‘password-here’) WHERE User=’your-user’ AND Host=’localhost’;

FLUSH PRIVILEGES; 

Import data

mysql -u<username> -p<password> -h<hostname> <database_name> < dump.sql

Leave a Reply

Your email address will not be published. Required fields are marked *