mysql

MySQL FAQ

in
MySQL
delete from mysql.user where user='username' and host='localhost';
flush privileges;<
grant all privileges on dbname.* to username@localhost identified by 'password';
flush privileges;<

Edit /etc/init.d/mysqld:

/usr/bin/mysqld_safe ... --skip-grant-tables<

Restart database

service mysqld restart<

Enter database

mysql -uroot mysql<

Update password

UPDATE user SET Password=PASSWORD('NewPass') WHERE Host='localhost' AND User='root';
flush privileges;
exit;<

Remove skip-grant-tables and restart database.

How to migrate from MySQL to PostgreSQL?

See related links
Syndicate content