The situation is that I have a MySQL database instance somewhere out on the network. And I’m trying to connect to it.<\/p>\n
Plan:<\/p>\n
[root@zyxx01 ~]# mysql -u root<\/span>
ERROR 1045 (28000): Access denied for<\/span> user 'root'<\/span>@'localhost'<\/span> (using password: NO)<\/pre>\nThat didn’t work. This does, though:<\/div>\n<\/p>\n
\n[root@zyxx01 ~]# mysql -u root -p<\/span>
Enter password: ****
Welcome to the MySQL monitor. Commands end<\/span> with ; or \\g.
Your MySQL connection id is 171310
Server version: 5.5.32-log MySQL Community Server (GPL)
mysql><\/pre>\n<\/div>\n
So, don’t forget the -p option on the command-line. I guess that it tries first to connect without a password, which is a possible configuration for MySQL. And fails because it isn’t allowed in this instance.<\/p>\n
Logging in from remote machine<\/h3>\n
My first attempt here didn’t work either, because “mysql” actually runs a batch file which expands into:<\/p>\n
\nD:\\>c:\\progra~1\\mysql\\mysqls~1.5\\bin\\mysql.exe --defaults-file=c:\\ProgramData\\MySQL\\mysqls~1.5\\my.ini -uroot -p
Enter password: ********
ERROR 2003 (HY000): Can't connect to MySQL server on '<\/span>localhost' (10061)<\/pre>\n<\/div>\n
Invoking the .exe directly avoids that interesting “defaults-file” thing:<\/p>\n
\nD:\\>c:\\progra~1\\mysql\\mysqls~1.5\\bin\\mysql.exe -h 192.168.1.130 -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end<\/span> with ; or \\g.
Your MySQL connection id is 204151
Server version: 5.5.32-log MySQL Community Server (GPL)
Copyright (c) 2000, 2012, 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.
Type 'help;'<\/span> or '\\h'<\/span> for<\/span> help. Type '\\c'<\/span> to clear the current input statement.
mysql><\/pre>\n<\/div>\n
Cool, we’re in. So now, let’s create a user:<\/p>\n
\nmysql> create<\/span> user<\/span> 'abacab'<\/span>@'%'<\/span> identified by<\/span> '****'<\/span>;
Query OK, 0 rows<\/span> affected (0.00 sec)
mysql> grant<\/span> all<\/span> privileges<\/span> on<\/span> *.* to<\/span> 'abacab'<\/span>@'%'<\/span> ;
Query OK, 0 rows<\/span> affected (0.00 sec)
mysql> flush privileges<\/span>;
Query OK, 0 rows<\/span> affected (0.00 sec)
mysql><\/pre>\n<\/div>\n
Testing the user:<\/p>\n
\nD:\\>c:\\progra~1\\mysql\\mysqls~1.5\\bin\\mysql.exe -h 192.168.1.130 -u abacab -p
Enter password: ***********
Welcome to<\/span> the MySQL monitor. Commands end<\/span> with<\/span> ; or<\/span> \\g.
Your MySQL connection<\/span> id is<\/span> 206648
Server version: 5.5.32-log MySQL Community Server (GPL)
...
mysql><\/pre>\n<\/div>\n
Success.<\/p>\n","protected":false},"excerpt":{"rendered":"
The situation is that I have a MySQL database instance somewhere out on the network. And I’m trying to connect to it. Logging in from the DB host Plan: Open a terminal window on the DB host, 192.168.1.130 Attempt to connect as the root db user [root@zyxx01 ~]# mysql -u rootERROR 1045 (28000): Access denied […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-26","post","type-post","status-publish","format-standard","hentry","category-mysql","post-preview"],"_links":{"self":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts\/26","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/comments?post=26"}],"version-history":[{"count":0,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"wp:attachment":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}