![]() ![]() Save the file, and from now on, you will get the log-in screen and have to use a username and password. While you are logged in phpMyAdmin as root, you can change/set the password.) (If you are still using the user 'root' with password '', you probably should change that. $cfg = 'random string' Īround line 19, change the authentication type to cookie $cfg = 'cookie' /*DEFAULT: 'config'ĭelete the three lines that are storing your password. As the file comments say, this string is used to encrypt your password in cookie based authentication (which is what you are about to change to). (Recommended) Change the blowfish_secret to any random string. I am going to list the changes in the order they occur in the file. You can see for more information, if you want to know your other options. You have to make two changes to the the file in order for this to happen, and a third change is strongly recommended for security. To have the log in screen appear, you want to change to use the 'cookie' authentication. You will also see your name and password. Since you are not seeing a log-in screen, you probably have If you have a default installation of phpMyAdmin,you are using the 'config' authentication, and your name and password are stored in the file. After creating the database, and went to phpmyadmin to create a new user and his privileges, but theres no privileges tab in phpmyadmin. ![]() But the comments say they're already supposed to be a read-only user. Then I thought to perhaps comment out the $cfg and $cfg. #1045 - Access denied for user (using password: ![]() Not even a single privilege is having for that user. By mistake, I changed all the privileges of user 'root' in my MySQL Database. So type root as the user, leave the password empty, and click on Go. All users are having NO Privileges in phpMyAdmin. I tried commenting out $cfg, and $cfg googletorp suggested - that perhaps it would present me with a login screen. By default the phpMyAdmin user is root and there is no password. I've seen login screens as googletorp suggested when i used pmas auto-installed by hosts but never on the out-of-the-box versions i've installed. Optimally I want him to be able to go to phpmyadmin UI, but only have the abilities allowed (in this case read-only).ĭo I need to set up a separate phpmyadmin where the controlling user is this weaker user? Or is there a special "log in as a specific user" interface I've missed in the documentation? TO 'username''localhost' IDENTIFIED BY 'password' If ALL PRIVILEGES is valid syntax and equates to the above, then you need something like: GRANT ALL PRIVILEGES ON dbname. I have created a new User with limited privileges, but I don't want My non-techie to have to use a command prompt and learn mysql commands. The Drupal doco says to do the following: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON databasename. without me having to build a special database-viewer-app.without any ability to alter/insert/delete.I want a non-techie (marketing/sales) to have access to the data I manage regularly via phpMyAdmin: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |