Geek asks and answers

WebMatrix Error "The specified password for the user account" root "is not valid ..."

When creating a new Joomla, Drupal or any website that uses the database from the "Application Gallery", I get errors:

MySQL

"The specified password for the user account" root "is invalid or could not connect to the database server"

SQL Server

"The specified password for the user account" sa "is invalid or could not connect to the database server"

What can be done to stop this error? I don’t believe this in databases, I blame WebMatrix because it is the same problem for both databases.

Thanks in advance

+5
source share
4 answers

, , :

  • Sql Server Management Studio Administartor

  • . \SQLEXPRESS, Windows

  • "" → "" → "sa" Ok

  • WebMatrix, .

+3

SQL Server , - . \SQLExpress, WebMatrix Joomla, "sa" . \SQLExpress. .

0

MySQL: : reset root.

  • MySQL, .

  • , , . : ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

  • MySQL Client cmd,

    C:> cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"

    C:> mysqld --init-file=C:\mysql-init.txt

  • .

, , Web Platform.

: http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html.

0

More articles:


All Articles