[[https://docs.tektinkers.com|TinkersDocs Home]]
[[https://www.tektinkers.com|Back to tektinkers.com]]

====== Commands to Setup a MySQL server in Ubuntu 22. ======

**Installing MySQL**

<code>sudo apt install mysql-server</code>
<code>sudo mysql</code>
//change "root" and "password" to whatever you want//
<code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';</code>
<code>exit</code>
<code>sudo mysql_secure_installation</code>

**MySQL: Creating Users and Databases**

<code>sudo mysql -u root -p</code>

//Change "example_database", "example_user" and "password" to whatever you want://
<code>CREATE DATABASE example_database;</code>
<code>CREATE USER 'example_user'@'%' IDENTIFIED BY 'password';</code>

//OPTIONAL - Change password of users://
<code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';</code>

<code>GRANT ALL ON example_database.* TO 'example_user'@'%';</code>
<code>exit</code>