设置密码
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD('root') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;
在丢失root密码的时候,可以这样
mysqld_safe --skip-grant-tables&
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';
mysql> FLUSH PRIVILEGES;
连接
mysql -h localhost -P3306 -u root -proot
mysql -h 127.0.0.1 -P3306 -u root -p
允许远程登陆<添加admin帐号>
mysql> use mysql;
mysql> GRANT ALL ON *.* TO admin@'%' IDENTIFIED BY 'admin' WITH GRANT OPTION;
#这句话的意思 ,允许任何IP地址(上面的 % 就是这个意思)的电脑 用admin帐户 和密码(admin)来访问这个MySQL Server
#必须加类似这样的帐户,才可以远程登陆。 root帐户是无法远程登陆的,只可以本地登陆
设置connect_timeout
mysql -h localhost -P8083 -u root -proot
set global connect_timeout=60;
FLUSH PRIVILEGES;
update user set host = '%' where user = 'root';
例如,你想root使用123456从任何主机连接到mysql服务器。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;