Install MySQL at WSL: Difference between revisions
From WikiMLT
m Стадий: 4 [Фаза:Авторизиране, Статус:Разработен]; Категория:Databases |
mNo edit summary |
||
(2 intermediate revisions by the same user not shown) | |||
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> | ||
Line 60: | Line 65: | ||
{{devStage | {{devStage | ||
| Прндл = Databases | | Прндл = Databases | ||
| Стадий = | | Стадий = 6 | ||
| Фаза = | | Фаза = Утвърждаване | ||
| Статус = | | Статус = Утвърден | ||
| ИдтПт = Spas | | ИдтПт = Spas | ||
| РзбПт = Spas | | РзбПт = Spas | ||
| АвтПт = {{REVISIONUSER}} | | АвтПт = Spas | ||
| УтвПт = {{REVISIONUSER}} | |||
| ИдтДт = 12.02.2023 | | ИдтДт = 12.02.2023 | ||
| РзбДт = 12.02.2023 | | РзбДт = 12.02.2023 | ||
| АвтДт = {{Today}} | | АвтДт = 12.02.2023 | ||
| УтвДт = {{Today}} | |||
| ИдтРв = [[Special:Permalink/32228|32228]] | | ИдтРв = [[Special:Permalink/32228|32228]] | ||
| РзбРв = [[Special:Permalink/32231|32231]] | | РзбРв = [[Special:Permalink/32231|32231]] | ||
| АвтРв = {{REVISIONID}} | | АвтРв = [[Special:Permalink/32232|32232]] | ||
| УтвРв = {{REVISIONID}} | |||
}} | }} | ||
</div> | </div> | ||
</noinclude> | </noinclude> |
Latest revision as of 10: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