WampServer

I just installed WampServer 3.0 and I apologize if this is already addressed in the forums here but I could not find it. I've looked all over the web too. I've read Troubleshooting Tips as well and did everything in there. When I open up MySQL Console for the first time and try to run:

update mysql.user SET password=password("xxxxxx"
-> where user="root";

I get the following error:

ERROR 1054 (42S22): Unknown column 'password' in 'field list'

Could somebody point me to a thread that addresses this. I don't want to bother anyone with some trivial stuff like this. I'm trying to learn how to get this set up though.
Thank you kindly,
Eric

Hi,

The syntax is not same with all versions of MySQL because column name is not always "password"

For Mysql before 5.7 it is "password"

Since MySQL 5.7 it is "authentication_string"

To avoid problems, it is best not to change the contents of the MySQL tables directly but rather use the ALTER USER syntax

ALTER USER
'root'@'localhost' IDENTIFIED BY 'new_password';

see [dev.mysql.com]

or use PhpMyAdmin and Users Accounts

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 2 time(s). Last edit at 07/23/2016 04:14PM by Otomatic.