Install MySQL at WSL: Difference between revisions
From WikiMLT
m (Стадий: 6 [Фаза:Утвърждаване, Статус:Утвърден]; Категория:Databases) |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<noinclude><!--[[Category:Databases|?]]-->{{ContentArticleHeader/Databases}}</noinclude> | <noinclude><!--[[Category:Databases|?]]-->{{ContentArticleHeader/Databases}}</noinclude> | ||
== Install MySQL == | |||
Install <code>mysql-server</code> and <code>mysql-client</code>.<syntaxhighlight lang="shell" class="code-continue" line="1"> | Install <code>mysql-server</code> and <code>mysql-client</code>.<syntaxhighlight lang="shell" class="code-continue" line="1"> | ||
sudo apt install -y mysql-client mysql-server | sudo apt install -y mysql-client mysql-server | ||
| Line 6: | Line 9: | ||
mysql --version | mysql --version | ||
</syntaxhighlight> | </syntaxhighlight> | ||
== Setup a User with MySQL Native Authentication == | |||
Then create a MySQL user that is able to log-in into the MySQL server by using native authentication. Gran to the user all privileges. | Then create a MySQL user that is able to log-in into the MySQL server by using native authentication. Gran to the user all privileges. | ||
<syntaxhighlight lang="shell" class="code-continue" line="1"> | <syntaxhighlight lang="shell" class="code-continue" line="1"> | ||
| Line 51: | Line 56: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
References | == References == | ||
* [https://askubuntu.com/q/1382572/566421 Open Ubuntu terminal using batch file on windows with command?] | * [https://askubuntu.com/q/1382572/566421 Open Ubuntu terminal using batch file on windows with command?] | ||
* [https://askubuntu.com/q/1165969/566421 Ubuntu 18.04 on WSL Cron daemon not running after reboot] | * [https://askubuntu.com/q/1165969/566421 Ubuntu 18.04 on WSL Cron daemon not running after reboot] | ||
* [https://kontext.tech/column/sql-databases/615/install-mysql-on-wsl Context.tech: Install MySQL on WSL] | |||
<noinclude> | <noinclude> | ||
Latest revision as of 11:53, 12 February 2023
Install MySQL
Install mysql-server and mysql-client.
sudo apt install -y mysql-client mysql-server
sudo service mysql start
sudo service mysql status
mysql --version
Setup a User with MySQL Native Authentication
Then create a MySQL user that is able to log-in into the MySQL server by using native authentication. Gran to the user all privileges.
sudo mysql
CREATE USER 'local_admin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'local_admin_password_1!2@3#';
GRANT ALL PRIVILEGES ON *.* TO 'local_admin'@'localhost' WITH GRANT OPTION;
SELECT user,plugin,host FROM mysql.user WHERE host = 'localhost';
+------------------+-----------------------+-----------+
| user | plugin | host |
+------------------+-----------------------+-----------+
| debian-sys-maint | caching_sha2_password | localhost |
| local_admin | mysql_native_password | localhost |
| mysql.infoschema | caching_sha2_password | localhost |
| mysql.session | caching_sha2_password | localhost |
| mysql.sys | caching_sha2_password | localhost |
| root | auth_socket | localhost |
+------------------+-----------------------+-----------+
6 rows in set (0.00 sec)
quit
Now log-in by that user in order to test it and create one new empty data base for the further tests.
mysql -u'local_admin' -p'local_admin_password_1!2@3#'
CREATE DATABASE nodejs_w3s_tests;
Query OK, 1 row affected (0.01 sec)
quit
In order to start the MySQL server automatically at user log-in, create or update the file wsl-services.bat, located in the Windows user's folder shell:startup, with the following entry.
wsl-services.bat
C:\Windows\System32\wsl.exe -u root /etc/init.d/mysql start
References
- Open Ubuntu terminal using batch file on windows with command?
- Ubuntu 18.04 on WSL Cron daemon not running after reboot
- Context.tech: Install MySQL on WSL
