четверг, 22 января 2015 г.

MySql SuperUser Create

mysql -u [root] -p
> [password]
GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'userpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit

Wiki
http://www.heidisql.com/download.php
https://www.digitalocean.com/community/tutorials/mysql-ru
http://www.mysql.ru/docs/man/Adding_users.html

Info
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h name.domen.ru password 'new-password'

Alternatively you can run:

/usr/bin/mysql_secure_installation

Комментариев нет:

Отправить комментарий

Failed to install module libnvdimmvmxnet3

The fix is this: in /etc/dracut.conf.d/*.conf > nvdimm-security.conf > vmware-tools.conf, edit the "add_drivers" line to ...