1、链接mysql:(以root账号登录)
mysql -u root -p
初始没有密码,直接enter
注意:当配置文件中将Mysql端口号更改了,则登录时需指定端口,P为大写:(这里我设置的端口为3309,,主机ip为192.168.168.152)
mysql -P 3309 -h 192.168.168.152 -u root -p
2、登录之后,修改密码,并配置远程访问
登陆成功之后修改密码(密码修改为admin):
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘admin’;
或者
update mysql.user set authentication_string=password(‘admin’) where user=‘root’ and Host = ‘localhost’;
默认不允许远程访问MySQL,如果需要远程访问,下面是开启远程访问的命令:
use mysql;
update user set host = ‘%’ where user = ‘root’;
FLUSH PRIVILEGES;
如果是ubuntu可以直接sudo mysql,然后再修改密码ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘admin’;