0

I created a new administrator account when I upgraded to MySQL server 8.0.15 in windows 10.

However, I am not able to log into the server using mysql -u root -p. So, I tried using the newly created user account and attempted to start the server. Here's the things I have done :-

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysql -u -p
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>net start mysql
The service name is invalid.

More help is available by typing NET HELPMSG 2185.


C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysqld install
Service successfully installed.

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysql -u -p
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>net start mysql
The MySQL service is starting.
The MySQL service could not be started.

The service did not report an error.

More help is available by typing NET HELPMSG 3534.


C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysqld --initialize

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>net start mysql
The MySQL service is starting....
The MySQL service was started successfully.


C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysql -u -p
ERROR 1045 (28000): Access denied for user '-p'@'localhost' (using password: NO)

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysql -u root -p
Enter password: ********
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysqladmin -u root password [newpassword]
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'


C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysql GRANT ALL PRIVILEGES ON *.* TO 'abc'@'localhost' IDENTIFIED BY 'x123';
mysql  Ver 8.0.15 for Win64 on x86_64 (MySQL Community Server - GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Usage: mysql [OPTIONS] [database]
  -?, --help          Display this help and exit.
  -I, --help          Synonym for -?
  --auto-rehash       Enable automatic rehashing. One doesn't need to use
                      'rehash' to get table and field completion ....

I have been struggling for many hours on this and I havn't the faintest idea how to make my connection work. Any help is greatly appreciated. Tks.

Lacek
  • 7,233
  • 24
  • 28
Karen Goh
  • 1
  • 3
  • 1
    Have you looked at the log files of mysqld? – Gerald Schneider Mar 01 '19 at 09:36
  • The procedure to reset the root password is well documented: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html – Gerald Schneider Mar 01 '19 at 09:40
  • @Gerald Schneider I am not sure how to do it. Please help me. Tks. – Karen Goh Mar 01 '19 at 12:19
  • 2019-02-28T08:52:21.532732Z 0 [ERROR] [MY-010361] [Server] Fatal error: Illegal or unknown default time zone 'Asia/Singapore' 2019-02-28T08:52:21.614479Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-02-28T08:52:23.802846Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0.15\bin\mysqld.exe: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL. – Karen Goh Mar 04 '19 at 02:11

0 Answers0