phpmyadmin error on login
Posted by: nickr (---.91-182-65.nts-online.net)
Date: March 13, 2017 09:39PM

Windows version used : Windows 7 64 bit
Version WampServer : 3.06 64 bit
Apache Version: 2.4.23
PHP Version: 5.6.25
MySQL Version: 5.7.14
What color is the WampServer icon : green

Do you have access to localhost (Homepage WampServer)? Yes
is there an error message at the bottom of the page? No

Do you have access to phpMyAdmin? Sort of. Able to see login page and upon entering correct credentials see the error listed below.
If you refer to an error message, please include the EXACT wording of the error in your post:

ERROR
SQL query:
SET lc_messages = 'en_US';
MySQL said:
#1193 - Unknown system variable 'lc_messages'

If you use an Antivirus and / or Firewall, please include the names of these: no
What is the full path to the installation of WampServer (eg D:\wamp\): C:\wamp64
If you have one or more Virtual Hosts defined, please show their definition(s): just local host

#########################################################################

Hello,
I left work Friday with my yii2 site hosted on my wamp server working completely normal, when i returned today i was greeted by a familiar issue (second time) where phpmyadmin gives me this error upon login and my web site wont load (assuming this is related to the phpmyadmin problem as it spits a sql connection related error ). Last time i did this i did a fresh install of wamp and copied my site over resulting in it working until the problem surfaced again. I understand that the error message usually points to the my.ini file however from what i read mine seems to be correct listing lc-messages as:

###my.ini
;Path to the language
;See Documentation:
; [dev.mysql.com]
lc-messages-dir="c:/wamp64/bin/mysql/mysql5.7.14/share"
lc-messages=en_US

Writing out this question i am noticing the inconsistency between the underscore in the error statement and my file wamp is displaying.

Please advise, Thanks.

Options: ReplyQuote
Re: phpmyadmin error on login
Posted by: Archaismic (---.hfc.comcastbusiness.net)
Date: March 14, 2017 02:12AM

Have you set up a good strong password for your sql root user?

There are a number of crawlers that look for new sql databases and will mess with them if the password is blank or weak.

Did you check the status of your database manually? i.e. through command prompt and see if it was just a php issue and not the database?

Were there any windows updates in between the install and the failure?

Did the website continue to operate even though the phpmyadmin wasn't working?

Options: ReplyQuote
Re: phpmyadmin error on login
Posted by: RiggsFolly (Moderator)
Date: March 14, 2017 11:29AM

Hi Nickr,

Can you tell us what version of phpMyAdmin you are using please.

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: phpmyadmin error on login
Posted by: nickr (---.lbbkcmtk04.res.dyn.suddenlink.net)
Date: March 15, 2017 04:25PM

Hello,

Thanks for your replies. I am unsure of the phpmyadmin version (but it is from the latest download) right now as i am not at work but will get that here in a hour or two. The website went down as well with a sql related error. I will post back here with my versions, errors and console status asap

thanks

Options: ReplyQuote
Re: phpmyadmin error on login
Posted by: nickr (---.91-182-65.nts-online.net)
Date: March 15, 2017 06:51PM

PHP Myadmin version 4.6.4 as listed in my apps directory inside of wamp


mysql> status
--------------
c:/wamp64/bin/mysql/mysql5.7.14/bin/mysql.exe Ver 14.14 Distrib 5.7.14, for Win
64 (x86_64)

Connection id: 19
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.72-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: cp850
Conn. characterset: cp850
TCP port: 3306
Uptime: 1 day 21 hours 42 min 34 sec

Threads: 1 Questions: 16 Slow queries: 0 Opens: 15 Flush tables: 1 Open tab
les: 0 Queries per second avg: 0.0
--------------

My website does not work now throwing this error

"SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)"

but given that status was good why would this interfere?

i am having trouble figuring out the source of the problem is, but might just go ahead and reinstall once more.

Options: ReplyQuote
Re: phpmyadmin error on login
Posted by: nickr (---.91-182-65.nts-online.net)
Date: March 15, 2017 06:55PM

MY PHP ERROR LOG
[pastebin.com]


MYSQL
[pastebin.com]

APACHE
[pastebin.com]

Options: ReplyQuote
Re: phpmyadmin error on login
Posted by: nickr (---.91-182-65.nts-online.net)
Date: March 15, 2017 10:06PM

So I reinstalled wamp and its working again with my website and everything. Let me know if there is any info I could provide while it is still working. I am assuming the same issue will present itself again and will keep you updated.

Options: ReplyQuote


Sorry, only registered users may post in this forum.