mysqlCreate user with root privileges

CREATE USER user@localhost IDENTIFIED BY 'pwd';
GRANT ALL PRIVILEGES ON *.* TO user@localhost WITH GRANT OPTION;
FLUSH PRIVILEGES;ctrl + cyoutubegithub

`CREATE USER` creates specified user	`user@localhost` user name and host to attach it to
`GRANT ALL PRIVILEGES` grants any operation for specified user	`ON .` allow access to all tables of all databases
`TO user@localhost` user we want to grant access to (our newely created user)	`IDENTIFIED BY 'pwd'` set `pwd` password for our user
`FLUSH PRIVILEGES` will make sure new user access is granted instantly	`WITH GRANT OPTION` allow user to grant access to other users

Create user with full access to single database

More of Mysql

How to find duplicate varchar/text column values in table
Disable ONLY_FULL_GROUP_BY mode
Get largest tables list
Truncate all tables in a specific database
Insert new values only if row doesn't exist already
Make a pager (limit / offset) select query
What is the MEDIUMTEXT column max size (length) in Mysql
How to find my.cnf config file
Insert/update multiple rows in single query
What is the LONGTEXT column max size (length) in Mysql

See more codes...

mysqlCreate user with root privileges

Related

More of Mysql