![]() ![]() At this prompt type the following: (Where ******** is the new password, NOTE: the single quotes ARE REQUIRED) mysql> UPDATE er SET Password=PASSWORD('********') WHERE User='root' įlush privileges will make the change take effect immediately. at the console, type: mysqld_safe -skip-grant-tables -autoclose.To change the mysql password for the root user, do the following: Editing an existing user To edit an existing user, simply click the pencil icon to the right of that user in the Users page. PS: contains more interesting settings :)įollow the root password change if you dont know the root password and then login in, it worked for me. In general, users do not need any global privileges (other than USAGE), only permissions for their specific database. So you get: $cfg = 'cookie' (or http if you wish)ģ) clear/delete all browser cookies for your server (usually look for localhost or 127.0.0.1 cookies)Ĥ) Go to phpyadmin's webpage again - now you will be prompted with login box (html or http - depends on whether you set the cookie or http)ĥ) LOGIN - AND YOU'RE DONE ! :) Suddenly 'Privileges'/'Users' tab is shown, the exit button appears suddenly too ! :) (next to the "little house"-left-top) $cfg = 'SOMETHING' - change 'SOMETHING' to 'cookie' I'm using Remote Desktop Connection through my Windows 10 Desktop, to connect the Raspberry Pi 3. But these privilege changes do not survive a reboot i.e. When I login to PHPMyAdmin and type in Password, Main Screen of PHPMyAdmin, No 'User Tab' and when I Press 'Database Tab' Create Database 'No Privileges'. This is fine because I can give the user full privileges and the problem disappears. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |