MySQL Forums
Forum List  »  Newbie

Re: MySQL Error Number 2003
Posted by: molo lo
Date: August 16, 2022 10:33PM

mysql> select user, host, plugin, authentication_string from mysql.user order by user, user;
+------------------+-----------+-----------------------+------------------------------------------------------------------------+
| user | host | plugin | authentication_string |
+------------------+-----------+-----------------------+------------------------------------------------------------------------+
| mysql.infoschema | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| root | localhost | caching_sha2_password | $A$005$%RA~mXl,ocyf"4VCAZpdDBn8ahJ2Pji4v6sEwHy95EPJCh4CoVLl4MbCiCd/ |
'Otyf(X'pPZxkqLrx5W8YVkDhV4k.79drNY8unLnAEopQs61H/AB9 || $A$005$,~3k
+------------------+-----------+-----------------------+------------------------------------------------------------------------+
5 rows in set (0.00 sec)

mysql>


One more point, I don't know why I got one more statement when I login my MySQL:

mysql: [Warning] World-writable config file '/etc/my.cnf' is ignored.




$ mysql -u root -p
mysql: [Warning] World-writable config file '/etc/my.cnf' is ignored.
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.30 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

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

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Options: ReplyQuote


Subject
Written By
Posted
August 16, 2022 03:14AM
August 16, 2022 03:16AM
October 11, 2022 01:34AM
August 16, 2022 10:27AM
August 16, 2022 09:07PM
August 16, 2022 09:29PM
Re: MySQL Error Number 2003
August 16, 2022 10:33PM
August 16, 2022 10:37PM
August 17, 2022 10:08AM
August 18, 2022 01:13AM
August 18, 2022 10:02PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.