Securing MySQL Server - setup root password

关注

转载最新推荐文章于 2026-09-02 11:42:39 发布 1.3k 阅读 AI 写同款· GEO 优化 ›

WSL 安装 MySQL 安装 apt 库有现成的包，直接执行命令安装 sudo apt install mysql-server 配置执行以下命令 sudo mysql_secure_installation 可能会出现以下报错： Securing the MySQL server deployment. Enter password for user root: Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysql 阅读详情

Securing MySQL Server - setup root password

As you see MySQL server connects without any password restriction. This is not a good idea for production environment so let us setup root password with mysqladmin command. By default MySQL server installs without any password and it use root account as admin user for managing MySQL server. Please do not get confused with FreeBSD root user account. Both are different account and password for both accounts should be different for security reasons.

$ mysqladmin -u root password MYPASSWORD

Now try to connect server:

$ mysql

Output:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

To connect to MySQL server use following syntax (when prompted for password type newly set password):

$ mysql -u root -p

Output

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 4 to server version: 5.0.9-beta

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql>

Now your server is secured and no one can connect to MySQL server anonymously.
See also:

MySQL change root password - it covers few other methods for setting up MySQL root/admin password.

Securing MySQL Server - setup root password

$ mysqladmin -u root password MYPASSWORD

Now try to connect server:

$ mysql

Output:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

To connect to MySQL server use following syntax (when prompted for password type newly set password):

$ mysql -u root -p

Output

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 4 to server version: 5.0.9-beta

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql>

Now your server is secured and no one can connect to MySQL server anonymously.
See also: