# mySql

# User administration

# Add new user, set password and grant permissions

CREATE USER 'novousuario'@'localhost' IDENTIFIED BY 'password';  
GRANT ALL PRIVILEGES ON \* . \* TO 'novousuario'@'localhost';  
FLUSH PRIVILEGES;

<span class="hljs-keyword">CREATE</span> DATABASE nome\_da\_base\_de\_dados;

CREATE USER 'nome\_do\_usuario'@'localhost' IDENTIFIED BY 'senha';  
GRANT ALL PRIVILEGES ON nome\_da\_base\_de\_dados.\* TO 'nome\_do\_usuario'@'localhost';  
FLUSH PRIVILEGES;

  
Para alterar a password:

<div class="dark bg-gray-950 contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative" id="bkmrk-alter-user-%27usuario%27"><div class="overflow-y-auto p-4" dir="ltr">`<span class="hljs-keyword">ALTER</span> <span class="hljs-keyword">USER</span> <span class="hljs-string">'usuario'</span>@<span class="hljs-string">'host'</span> IDENTIFIED <span class="hljs-keyword">BY</span> <span class="hljs-string">'nova_senha'</span>;`</div></div> FLUSH PRIVILEGES;

Se o MySQL estiver em uma versão anterior a 5.7.6, o comando seria:

SET PASSWORD FOR 'usuario'@'host' = PASSWORD('nova\_senha');

# Reset root password

sudo /etc/init.d/mysqld stop  
sudo /etc/init.d/mysqld status  
sudo mysqld\_safe --skip-grant-tables &amp;  
mysql -u root

use mysql;  
update user set password=PASSWORD("mynewpassword") where User='root';  
flush privileges;  
exit

sudo /etc/init.d/mysqld stop  
sudo /etc/init.d/mysqld status  
sudo /etc/init.d/mysqld start  
sudo /etc/init.d/mysqld status

https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/

# Exporting data

# Dumping data

#### One Insert statement for each data row

mysqldump --extended-insert=FALSE

# Settings

Store passwords

Edit the file ~/.my.cnf and adapt the following code:

\[client\]  
user=root  
password="pass"

\[mysql\]  
user=root  
password="pass"

\[mysqldump\]  
user=root  
password="pass"

\[mysqldiff\]  
user=root  
password="pass"