Install MySQL at WSL: Difference between revisions

From WikiMLT
Browse history interactively
← Older edit
VisualWikitext
Spas (talk | contribs)
Image-reviewer, Public, Bots, Bureaucrats, Check users, Structured Discussions bots, Interface administrators, Oversighters, smwadministrator, smwcurator, Suppressors, Administrators, translator, Upload Wizard campaign editors, widgeteditor
31,253 edits
m Стадий: 3 [Фаза:Разработване, Статус:Разработван]; Категория:Databases
Spas (talk | contribs)
Image-reviewer, Public, Bots, Bureaucrats, Check users, Structured Discussions bots, Interface administrators, Oversighters, smwadministrator, smwcurator, Suppressors, Administrators, translator, Upload Wizard campaign editors, widgeteditor
31,253 edits
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude><!--[[Category:Databases|?]]-->{{ContentArticleHeader/Databases}}</noinclude>
<noinclude><!--[[Category:Databases|?]]-->{{ContentArticleHeader/Databases}}</noinclude>
== References ==


* ...
== Install MySQL ==
 
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 service mysql start
sudo service mysql status
mysql --version
</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.
<syntaxhighlight lang="shell" class="code-continue" line="1">
sudo mysql
</syntaxhighlight>
<syntaxhighlight lang="mysql" line="1" class="code-continue">
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';
</syntaxhighlight><syntaxhighlight lang="text" highlight="5" class="code-continue">
+------------------+-----------------------+-----------+
| 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)
</syntaxhighlight>
<syntaxhighlight lang="mysql" line="1" start="4">
quit
</syntaxhighlight>
Now log-in by that user in order to test it and create one new empty data base for the further tests.
<syntaxhighlight lang="shell" class="code-continue" line="1">
mysql -u'local_admin' -p'local_admin_password_1!2@3#'
</syntaxhighlight>
<syntaxhighlight lang="mysql" line="1" class="code-continue">
CREATE DATABASE nodejs_w3s_tests;
</syntaxhighlight>
<syntaxhighlight lang="text" class="code-continue">
Query OK, 1 row affected (0.01 sec)
</syntaxhighlight>
<syntaxhighlight lang="mysql" line="1" start="2">
quit
</syntaxhighlight>
In order to start the MySQL server automatically at user log-in, create or update the file <code>wsl-services.bat</code>, located in the Windows user's folder <code>[https://www.softwareok.com/?seite=faq-Windows-10&faq=151 shell:startup]</code>, with the following entry.
<syntaxhighlight lang="shell" class="code-continue">
wsl-services.bat
</syntaxhighlight>
<syntaxhighlight lang="text">
C:\Windows\System32\wsl.exe -u root /etc/init.d/mysql start
</syntaxhighlight>


== Section 1 ==
== References ==
...
* [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://kontext.tech/column/sql-databases/615/install-mysql-on-wsl Context.tech: Install MySQL on WSL]


<noinclude>
<noinclude>
Line 13: Line 65:
{{devStage  
{{devStage  
  | Прндл  = Databases
  | Прндл  = Databases
  | Стадий = 3
  | Стадий = 6
  | Фаза  = Разработване
  | Фаза  = Утвърждаване
  | Статус = Разработван
  | Статус = Утвърден
  | ИдтПт  = Spas
  | ИдтПт  = Spas
  | РзбПт  = {{REVISIONUSER}}
  | РзбПт = Spas
| АвтПт  = Spas
| УтвПт = {{REVISIONUSER}}
  | ИдтДт  = 12.02.2023
  | ИдтДт  = 12.02.2023
  | РзбДт  = {{Today}}
  | РзбДт = 12.02.2023
| АвтДт  = 12.02.2023
| УтвДт = {{Today}}
  | ИдтРв  = [[Special:Permalink/32228|32228]]
  | ИдтРв  = [[Special:Permalink/32228|32228]]
  | РзбРв  = {{REVISIONID}}
  | РзбРв = [[Special:Permalink/32231|32231]]
| АвтРв  = [[Special:Permalink/32232|32232]]
| УтвРв = {{REVISIONID}}
}}
}}
</div>
</div>
</noinclude>
</noinclude>

Latest revision as of 10:53, 12 February 2023

Data­bas­es

In­stall MySQL

In­stall mysql-serv­er and mysql-client.

sudo apt install -y mysql-client mysql-server
sudo service mysql start
sudo service mysql status
mysql --version

Set­up a User with MySQL Na­tive Au­then­ti­ca­tion

Then cre­ate a MySQL user that is able to log-in in­to the MySQL serv­er by us­ing na­tive au­then­ti­ca­tion. Gran to the user all priv­i­leges. 

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 or­der to test it and cre­ate one new emp­ty da­ta base for the fur­ther 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 or­der to start the MySQL serv­er au­to­mat­i­cal­ly at user log-in, cre­ate or up­date the file wsl-services.bat, lo­cat­ed in the Win­dows user's fold­er shell:startup, with the fol­low­ing en­try. 

wsl-services.bat

C:\Windows\System32\wsl.exe -u root /etc/init.d/mysql start

Ref­er­ences


Retrieved from "https://wiki.metalevel.tech/index.php?title=Install_MySQL_at_WSL&oldid=32238"