一台server上有两个MySQL实例分别占用3306,3307 端口,如何使用mysql_secure_installation去删除匿名用户呢?
$netstat -antp|grep mysqld
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::3307 :::* LISTEN 2780/./bin/mysqld
tcp 0 0 :::3308 :::* LISTEN 3127/./bin/mysqld
假设这两个MySQL都没有使用默认的路径/tmp/mysql.sock,而使用了自己配置的路径。
mysql_secure_installation
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
如果想对端口是3308的实例使用mysql_secure_installation,首先登陆3308实例,找到3308实例使用的socket文件
mysql> select @@socket;
+---------------------------------------+
| @@socket |
+---------------------------------------+
| /opt/db/mysql5.6/logs_3308/mysql.sock |
+---------------------------------------+
然后做个软链接到/tmp/mysql.sock
ln -s /opt/db/mysql5.6/logs_3308/mysql.sock /tmp/mysql.sock
$ ll /tmp/mysql.sock
lrwxrwxrwx 1 mysql db 37 Jun 29 19:07 /tmp/mysql.sock -> /opt/db/mysql5.6/logs_3308/mysql.sock
这个时候再执行mysql_secure_installation默认就是对3308的实例进行设置了。
执行完mysql_secure_installation后,记得删除掉创建的软链接。
rm /tmp/mysql.sock
$netstat -antp|grep mysqld
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::3307 :::* LISTEN 2780/./bin/mysqld
tcp 0 0 :::3308 :::* LISTEN 3127/./bin/mysqld
假设这两个MySQL都没有使用默认的路径/tmp/mysql.sock,而使用了自己配置的路径。
mysql_secure_installation
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
如果想对端口是3308的实例使用mysql_secure_installation,首先登陆3308实例,找到3308实例使用的socket文件
mysql> select @@socket;
+---------------------------------------+
| @@socket |
+---------------------------------------+
| /opt/db/mysql5.6/logs_3308/mysql.sock |
+---------------------------------------+
然后做个软链接到/tmp/mysql.sock
ln -s /opt/db/mysql5.6/logs_3308/mysql.sock /tmp/mysql.sock
$ ll /tmp/mysql.sock
lrwxrwxrwx 1 mysql db 37 Jun 29 19:07 /tmp/mysql.sock -> /opt/db/mysql5.6/logs_3308/mysql.sock
这个时候再执行mysql_secure_installation默认就是对3308的实例进行设置了。
执行完mysql_secure_installation后,记得删除掉创建的软链接。
rm /tmp/mysql.sock