Menu
I made a new user and from root I run the command:
GRANT ALL PRIVILEGES ON db.* TO 'USER'@'localhost' IDENTIFIED BY 'PASSWORD';
But then when I want to create a new database from user USER it always says:
Acces denied for user 'USER'@'localhost' to database 'database_name'
I neved used databases, so can anyone help me on how to create a database ?
855
mysql> CREATE USER 'linuxconfig'@'localhost' IDENTIFIED BY 'password_here'; Now it is time to grant permissions to our linuxconfig user so that it can create new databases. We will do this by granting them the CREATE permission with the following command. mysql> GRANT CREATE ON *.
This error means that your mysql server does not have enough free space. You need to check the file system size and please remove unwanted software(s) or installers or files.
Expand the database in which to create the new database user. Right-click the Security folder, point to New, and select User.... In the Database User - New dialog box, on the General page, select one of the following user types from the User type list: SQL user with login.
To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name. * TO 'username'@'localhost';
Try this
GRANT ALL PRIVILEGES ON *.* TO 'USER'@'localhost' IDENTIFIED BY 'PASSWORD';
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
