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
> [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
Комментариев нет:
Отправить комментарий