Fulltext results:

MySQL: Create User @info:mysql:user

3 Hits, Last modified: 9 years ago

EATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; GRANT USAGE ON * . * TO '{user}'@'%' IDENTIFIED BY '{... TIONS 0 ; CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </... T EXISTS `dbname` DEFAULT CHARACTER SET = 'utf8'; GRANT ALL ON `dbname`.* TO 'dbuser'@'dbhost' IDENTIFIED

MySQL: Grant Permissions @info:mysql:permissions

3 Hits, Last modified: 12 years ago

====== MySQL: Grant Permissions ====== ==== Grant Permissions ==== <code sql> GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin dat

MySQL: Create Database @info:mysql:database

2 Hits, Last modified: 12 years ago

EXISTS `{db}`; </code> ==== Create Database and Grant Rights to a User ==== <code sql> CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </c

MySQL: Change Password @info:mysql:user

1 Hits, Last modified: 11 years ago

''{user}'' with the name of the user. <code sql> GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{pass

MySQL: View Permissions @info:mysql:permissions

1 Hits, Last modified: 12 years ago

Permissions ==== <code sql> SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; </code> {{tag>admin database