CODEWITHSUNDEEP
mysqlphpmyadmin
Jorge
Jorge

Reputation: 615

phpMyAdmin in palapa web server won't work

I downloaded palapa web server on my Infinix Hot 2 but had problems configuring phpmyadmin. So I downloaded phpmyadmin using KSWEB and copied the folder to /pws/phpmyadmin and phpmyadmin started working. However, now I am having a problem with logging in to phpmyadmin on http:// 127.0.0.1:9999/phpmyadmin. When I use root as user and blank password, it gives me this error:

 #1045 - Access denied for user 'root'@'localhost' (using password: NO)

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

If I try using root as user and adminadmin as password as instructed by palapa web server website, I get the following:

Error

SQL query: Edit Edit

SET lc_messages = 'en_US';

MySQL said: Documentation

#1193 - Unknown system variable 'lc_messages'

I will be grateful for any help to get phpmyadmin running smoothly in pws.

Upvotes: 1

Views: 3860

Answers (2)

Ghamdan
Ghamdan

Reputation: 1

Version php == version mysql Check version

Upvotes: -1

Gerald Schneider
Gerald Schneider

Reputation: 17797

lc_messages is a variable that was introduced in MySQL 5.5, it replaces the old language commands (see release notes).

Palapa Web Server, on the other hand, ships with MySQL 5.1, where this variable doesn't exist yet, hence the error messages.

Download the right version of phpMyAdmin from the web site, currently version 4.0.10.17, which doesn't need MySQL 5.5 (the required versions are listed there).

Using this older version that matches your other components should fix the problem.

Upvotes: 4

Related Questions