mySql

• User administration
• Add new user, set password and grant permissions
• Reset root password
• Exporting data
• Dumping data
• Settings

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;

 

CREATE 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:

 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 &
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"