Menu
Im a newbie in ubuntu. Im getting an error while installing phpmyadmin in ubuntu11.4 server. It says
An error occurred while installing the database:
ERROR 1045 (28000):Access denaid for user 'root'@'localhost' (using password:YES);
I am sure that I used the correct password for root. I can login to mysql through putty.
Do I need to do anything with privileges?
Please help me to sort this issue.
394
Use ALTER USER 'root'@'localhost' IDENTIFIED BY 'PASSWORD'; FLUSH PRIVILEGES; EXIT; to set your password, then try phpMyAdmin again.
We'll walk through these options shortly: sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl.
NOTE: If successful, the above command will create an SSH tunnel but will not display any output on the server console. Access the phpMyAdmin console through the secure SSH tunnel you created, by browsing to http://127.0.0.1:8888/phpmyadmin. Log in to phpMyAdmin by using the following credentials: Username: root.
A: Access the terminal window on your Ubuntu server. Issue the command sudo apt-get install phpmyadmin php-mbstring php-gettext -y. Type in your sudo password when prompted, and then allow the installation to complete.
I suggest:
mysql -h localhost -u root -p
and you typed something else. :(
pidof mysqld says what exactly? If nothing then sudo service mysql start and try
mysql -h localhost -u root -p
again.
Re-configure mysql-server:
sudo dpkg-reconfigure mysql-server
or
sudo dpkg-reconfigure mysql-server-5.1
whichever one is installed.
Once you reconfigure (and recover) your root mysql password, then Reconfigure phpmyadmin
sudo dpkg-reconfigure phpmyadmin
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
