I tried the other way as well and it just ended up being difficult. I also had some problems with mysql just not accepting my password.
To install phpmyadmin on you server you will need to have 4 things:Īll packages can be found browsing synaptic.
An easy way to have a full control of your mysql server is phpmyadmin (software made in php that can give you a web interface that can be very usefull to people that havent got a lot of confidence with bash.
When you have completed all this steps ,you can easily access to your mysql server with the password you have set in the step before. Then stop the mysqld process and relaunch it with the classical way: sudo /etc/init.d/mysql stop
UPDATE user SET Password = PASSWORD('newpwd')
UPDATE er SET Password=PASSWORD('newpwd') WHERE User='root'.If you have a mysql root account that can connect from everywhere, you should also do:.SET PASSWORD FOR = PASSWORD('password').from the mysql prompt execute this command to be able to change any password.start the mysql client process using this command.sudo /usr/sbin/mysqld -skip-grant-tables -skip-networking &īecause you are not checking user privs at this point, it's safest to disable networking.Start the mysqld demon process using the -skip-grant-tables option with this command.Stop the mysql demon process using this command :.To reset your mysqld password just follow these instructions : It is a good thing to unplug your server from the network or at least disable remote access. įollowing this procedure, you will disable access control on the MySQL server. To resolve this problem ,a fast and always working way is the "Password Resetting". To find the Ubuntu Server Guide related to your specific version, please go to:Īre you looking at this page because you cannot access the mysql server installed on your pc/server when you were trying to see if it works well? Or do you receive error messages like the following? :ĮRROR 1045: Access denied for user: (Using Its contents are currently under review and being merged with the Ubuntu Server Guide. Please do not make any edits to this article. Phpmyadmin still display a blank page with it's favicon.This article should be cleaned-up to follow the content standards in the Wiki Guide. I added a phpinfo test page in phpmyadmin, i can see the whole page with php infos. I have restarted mysql to change password. Set php.ini to display all errors and setting errors to alway display at the start of index.php of my phpmyadmin folder.īut it fails to connect to mysql, in TCP/IP and in socket (i have running rails apps using mysql, i can login in console using a PW and see my DBs). Set ALL phpmyadmin folders to belong to www-data use. Is it a wrong root password ? How can root not be allowed to do something?
While uninstalling phpmyadmin with apt-get i encountered the following error :ĮRROR 1045 (28000): Access denied for user (using I cannot run any mysql command in my console because of the following error : ERROR 1045 (28000): Access denied for user (using password: NO) The root folder of phpmyadmin is a totally blank page. I already have rails app using this mysql, and i checked the mysql password in the config files. I cannot login using system password(root) or mysql passsword(also root) I am greeted by an invite similar to an apache protected folder (log/password displayed in a browser pop-up, not an html popup) asking for login pass. I just installed phpmyadmin and i am trying to login in /phpmyadminpath/setup.