In MySQL, you have a root user, and you’re able to create other users and grant them varying levels of permissions or privileges to access/create/modify MySQL databases. One thing that you might not know is the ability to create an anonymous user, which means that you (and your applications) can connect to your database without specifying a username and password.
For the creation of this anonymous user account, you can’t use PHPMyAdmin (a popular GUI-based MySQL management tool). What you need to do is to access MySQL via the command line (command prompt in Windows, terminal in Mac), and type the following commands:
mysql -u root -p
After which, you’ll be logged into MySQL. If you get an error that the command is not found, then you’ll need to modify your classpaths so that you can run the MySQL program directly. Alternatively, you can go to the directory in which your MySQL binary files or the application files are, and run that command from there.
Now run these following commands. Note that database-name is your database name, and table-name is your table name.
mysql> use database-name;
mysql> GRANT SELECT ON table-name TO ”@localhost
That will grant “select” privileges to the anonymous user. If you want to grant all privileges, or if you want the privileges to apply to all tables, then you can use a variant of the following command. What it does is to grant all privileges to all tables in your database.
mysql> GRANT ALL PRIVILEGES ON *.* TO ”@localhost
- How To Reset The MySQL Root User Password and Privileges
- How to find and replace text string in all MySQL tables
- How To Randomly Select From A Record Based On Weight (PHP, MySQL)
- Example FTP Session in UNIX
- How To Mass Update WordPress URLs After a Site Migration