记WSL下MySQL安装和使用BUG

最新推荐文章于 2023-05-12 17:29:31 发布

Kaiz‘s Blog

最新推荐文章于 2023-05-12 17:29:31 发布

阅读量629

点赞数 2

分类专栏：错误记录

本文链接：https://blog.csdn.net/KAIZ_LEARN/article/details/117289934

版权

本文档记录了在WSL环境下安装MySQL过程中遇到的两个问题：一是安装时权限不足导致的目录创建错误，二是设置密码时不符合策略要求。针对这些问题，提供了详细的操作步骤和解决方案，包括修改wsl-integration.sh文件、调整权限和更新密码策略。

摘要由CSDN通过智能技术生成

这里完全按照WSL官网安装MySQL

To install MySQL on WSL (Ubuntu 18.04):

Open your WSL terminal (ie. Ubuntu 18.04).
Update your Ubuntu packages: sudo apt update
Once the packages have updated, install MySQL with: sudo apt install mysql-server
Confirm installation and get the version number: mysql --version

You may also want to run the included security script. This changes some of the less secure default options for things like remote root logins and sample users. To run the security script:

Start a MySQL server: sudo /etc/init.d/mysql start
Start the security script prompts: sudo mysql_secure_installation
The first prompt will ask whether you’d like to set up the Validate Password Plugin, which can be used to test the strength of your MySQL password. You will then set a password for the MySQL root user, decide whether or not to remove anonymous users, decide whether to allow the root user to login both locally and remotely, decide whether to remove the test database, and, lastly, decide whether to reload the privilege tables immediately.

To open the MySQL prompt, enter: sudo mysql

To see what databases you have available, in the MySQL prompt, enter: SHOW DATABASES;

To create a new database, enter: CREATE DATABASE database_name;

To delete a database, enter: DROP DATABASE database_name;

For more about working with MySQL databases, see the MySQL docs.

To work with with MySQL databases in VS Code, try the MySQL extension.

安装Bug： cannot create directory ‘//.cache’: Permission denied

然而，在执行sudo mysql这一步时，出现下面错误：

 * Starting MySQL database server mysqld                                                                                No directory, logging in with HOME=/
-su