[root@mysql_master1 ~]# mysql -uroot -p -hlocalhost -P3306
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.49-log MySQL Community Server (GPL)
Copyright (c)2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema || mysql || performance_schema ||test|
+--------------------+
4 rows inset(0.00 sec)
mysql>
通过mysql.sock文件登录:
#查找mysql对应的sock文件[root@mysql_master1 ~]# find /my_mysql/ -name "*.sock"
/my_mysql/3306/mysql.sock
/my_mysql/3307/mysql.sock
#查找mysql对应的pid文件[root@mysql_master1 ~]# find /my_mysql/ -name "*.pid"
/my_mysql/3306/data/mysql_master1.pid
/my_mysql/3307/data/mysql_master1.pid
[root@mysql_master1 ~]##通过sock文件登录[root@mysql_master1 ~]# mysql -S /my_mysql/3306/mysql.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.49-log MySQL Community Server (GPL)
Copyright (c)2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema || mysql || performance_schema ||test|
+--------------------+
4 rows inset(0.00 sec)
两种方式修改密码
- ip+port修改:
[root@mysql_master1 ~]# mysqladmin -uroot -p -hlocalhost -P3306 password
Enter password:
New password:
Confirm new password:
#此时已经需要输入密码才能登录[root@mysql_master1 ~]# mysql -uroot -p -hlocalhost -P3306
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.49-log MySQL Community Server (GPL)
Copyright (c)2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
mysql>
- sock方式修改:
#修改密码[root@mysql_master1 ~]# mysqladmin -uroot -S /my_mysql/3307/mysql.sock password
New password:
Confirm new password:
#加入-p参数,输入密码登录[root@mysql_master1 ~]# mysql -p -S /my_mysql/3307/mysql.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.49-log MySQL Community Server (GPL)
Copyright (c)2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
mysql>
直接远程登录,会出现报错,因为是没有授权的。
#使用这条命令,允许root用户在192.168.10.网段,远程登录的所以权限,all privileges表示开放所有的权限
mysql> grant all privileges on *.* to root@'192.168.10.%' identified by 'jiegege';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges
->;
Query OK, 0 rows affected (0.00 sec)
mysql>