MySQL - Конфигурирование пользователей после инсталляции

// Login as root database admin to MySQL server:
# mysql -u root

// Change root database admin password: (note: once this step is complete you’ll need to login with: mysql -p -u root)
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');

// Add a MySQL database:
mysql> create database mydatabase;

mysql> quit;

// Delete ALL users who are not root:
mysql> DELETE FROM mysql.user WHERE NOT (host="localhost" AND user="root");

// Remove anonymous access to the database(s):
mysql> DELETE FROM mysql.user WHERE User = '';

// Можно переименовать root
// Change root username to something less guessable for higher security.
mysql> update mysql.user set user="sysdba" where user="root";

// Add a new user with database admin privs for all databases:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'sysdba'@'localhost' IDENTIFIED BY 'mypass' WITH GRANT OPTION;

// Создать нового пользователя в базе данных
mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

// Ставил *, а нужно было %
mysql> CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';


// Предоставить все привелегии
mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%';

// Add a new user with database admin privs for a specific database, in this case the database is called “bugzilla”: (note: The ‘bugzilla’ database must first be added, see below.)
mysql> GRANT ALL PRIVILEGES ON bugzilla.* TO 'dba'@'localhost' IDENTIFIED BY 'mypass';

mysql> select User,Host from mysql.user;

mysql> SELECT CONCAT(QUOTE(user),'@',QUOTE(host)) UserAccount FROM mysql.user;

mysql> SHOW GRANTS FOR 'username'@'%';