Ubuntu – How to reconfigure phptheadmin

Apache2MySQLphpmyadmin

Error: "http://localhost/phpmyadmin/index.php"  

Cannot connect: invalid settings.   
Connection for controluser as defined in your configuration failed.

I was using LAMPP with mysql password as root. Then I installed xampp on Ubuntu 15.04. After that I'm unable to access my phpmyadmin page.

I tried changing config file removing cookies but still the same error.

Best Answer

run the command:

sudo dpkg-reconfigure phpmyadmin

You need to reconfigure it because lamp and xampp run phpmyadmin in different ports. So, it is probably a port conflict. You can also open server.xml in your lampp and change the port no. which would be different from that of xampp. Then both MySQL (of xampp and lamp as well) will run.

Related Solutions

Ubuntu – PhpMyAdmin login problem:

A confusing point for almost everyone who starts using mysql is that 'root' and 'root@localhost' are two different roles and as such could (and some would argue that they actually should) have different passwords. It is quite possible you are trying to log-in as user 'root@localhost' and you are providing the password for 'root' role.

If this is the case, you can remedy it quite easily. Log-in to the database server using the CLI tool mysql as user root like this:

mysql --user=root --password

The tool will ask for your root password (not system root but database root). Now you can modify the password of 'root'@'localhost' like this:

UPDATE mysql.user SET Password=PASSWORD('cleartext password')
  WHERE User='root' AND Host='localhost';
FLUSH PRIVILEGES;

Now try to log-in through phpMyAdmin using the newly set password.

Ubuntu – Phptheadmin doesn’t connection with true data

I think the reason of the problem is that in Ubuntu 18.04 the default authentication method for the MySQL's root user is socket authentication. For example within the command line you can login as root by using sudo mysql instead of mysql -u'root' -p.

You can switch to mysql_native_password or even better you can create another user for web login and grant all privileges to this user. So let's assume the user you want to create is named webroot - you can create it by the following commands:

$ sudo mysql
mysql> CREATE USER 'webroot'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_strong_password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'webroot'@'localhost' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit;

References:

Best Answer

Related Solutions

Ubuntu – PhpMyAdmin login problem:

Ubuntu – Phptheadmin doesn’t connection with true data

Related Question