MySQL安装和登录
- windows
- linux
- docker
安装
-
Linux
linux安装 -
启动
service mysql start
登录
账户
- windows
root ROOT - docker
root 123456 - linux
root ROOT
port
3306
密码修改问题
解决思路 通过/etc/my.cnf 修改来跳过密码登录
待登录成功后use mysql 修改密码
[root@localhost vincent]# vi /etc/my.cnf
[root@localhost vincent]# service mysql start
Starting MySQL. SUCCESS!
[root@localhost vincent]# mysql -u root #回车直接进
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22-log MySQL Community Server (GPL)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('ROOT'); #核心 通过这个语句修改mysql密码
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> exit
Bye
[root@localhost vincent]# mysql -uroot -p #测试 成功
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Navicat Windows远程连接linux服务器ip限制问题
mysql服务器有远程连接ip限制,解决办法:
‘yuzhi’–用户名,可自取
‘%’ --表示允许所以window电脑访问,学习一般这么设置,也可以写需要访问的电脑的ip地址
‘123456’ --密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'ROOT';
FLUSH PRIVILEGES
Navicat链接Ip地址问题2005报错
https://blog.csdn.net/m0_46457497/article/details/120460684