![]() to phpmyadminlocalhost Note Alternatively, if you are trying to delete a database you can use this command replacing username with the user in question. It is common practice, for example, for each unique MySQL database on a server to have its own unique user associated with it, such that only one single user has authentication access to one single database and vice-versa. We’ll be talking our default user, phpmyadmin, and granting them permissions to create a database within PhpMyAdmin. In most cases, you’ll be granting privileges to MySQL users based on the particular database that account should have access to. There are a wide range of flags and options available to the command, so you may wish to familiarize yourself with what GRANT can actually do by browsing through the official documentation. The GRANT command is capable of applying a wide variety of privileges, everything from the ability to CREATE tables and databases, read or write FILES, and even SHUTDOWN the server. Create a new database: Create a new user (only with local access) and grant privileges to this user on the new database. ![]() ![]() But it doesn't allow 'admin' to create database. How to create a read-only MySQL user REVOKE type of permission list separed by comma ON database name.table name FROM usernamehostname, user2. Now that you are at the mysqlcli prompt, you need only issue the GRANT command with the necessary options to apply the appropriate permissions. To do this through PHPMyAdmin, select any database and then click on SQL tab in the main window. 2 Answers Sorted by: 5 Something like this should work for you: Add skip-grant-tables in my.cnf file under the mysqld section or otherwise stop mysqld and start it with the -skip-grant-tables option. Following command provides all privilege in all databases for User 'admin'. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |