I installed XAMPP on my Majaro Linux, and the control panel says all servers start fine.
Going to localhost/phpmyadmin, I get this error message:
Error
MySQL said: Documentation
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I tried the following:
Changed user in line 31 in /opt/lampp/phpmyadmin/config.inc.php from
- Code: Select all
$cfg['Servers'][$i]['user'] = 'root';
That lets me get into phpmyadmin, but I can't do anything, e.g. create a new database:
#1044 User “@‘localhost’” has no permission to access database newDB
so there’s a username missing here before the @.
I also posted about it here: https://discuss.codecademy.com/t/error-incorrect-database-name/526878/15 and here:
https://forum.manjaro.org/t/cannot-create-database-in-phpmyadmin-xampp/15993