Save the file, and from now on, you will get the log-in screen and have to use a username and password. My solution, it will give all you privileges there are for given user (make sure phpmyadmin is your username that you're able to log in with): sudo mysql mysql> grant all on. While you are logged in phpMyAdmin as root, you can change/set the password.) After creating the database, and went to phpmyadmin to create a new user and his privileges, but theres no privileges tab in phpmyadmin. (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. The Drupal doco says to do the following: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON databasename. Since you are not seeing a log-in screen, you probably have Im not sure I know what we would be doing without Beekeeper, probably coming up with file based sharing system with checkout permissions on a SharePoint. If you have a default installation of phpMyAdmin,you are using the 'config' authentication, and your name and password are stored in the file. 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: I tried commenting out $cfg, and $cfg googletorp suggested - that perhaps it would present me with a login screen. 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. Without the PROCESS privilege, nonanonymous users have access to information about their own threads but not threads for other users, and anonymous users have. 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? 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. 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 |