sumitasok
5/18/2018 - 7:20 AM

Mysql Configurations

mysql configuration commands.

-- https://stackoverflow.com/questions/14779104/how-to-allow-remote-connection-to-mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

-- https://easyengine.io/tutorials/mysql/remote-access/
SELECT * from information_schema.user_privileges where grantee like "'root'%";
-- https://dev.mysql.com/doc/refman/8.0/en/set-password.html
SET PASSWORD FOR 'jeffrey'@'localhost' = 'auth_string';

SET PASSWORD = 'auth_string';

SELECT CURRENT_USER();

-- https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/
use mysql;

update user set password=PASSWORD("mynewpassword") where User='root';

flush privileges;

quit