MYSql config bind-address set to 0.0.0.0 but netstat shows different on Ubuntu

by

the bind address to 0.0.0.0 is just part of the steps for allowing it to accept remote connections. Those steps include the rem’ing out explicitly with # skip-networking

[mysqld]
bind-address    = 0.0.0.0
# skip-networking

And a server restart.

You then need a user,host combo for login and ideally a GRANT to a db to use with adequate (not excessive) rights.

You can see your current users with select user,host from mysql.user

Please see the MySQL Manual page on GRANT Syntax.

I wrote a little answer Here about the wildcard % host and other minor details.

An illustration for a test is below:

create schema testDB007;
use testDB007;

create table t1
(   id int not null
);

CREATE USER 'jeffrey123z'@'%' IDENTIFIED BY 'mypass123^';
-- note password is mypass123^

GRANT ALL ON testDB007.* TO 'jeffrey123z'@'%';
SHOW GRANTS FOR 'jeffrey123z'@'%';

enter image description here

Now, the blue row above (USAGE) means almost nothing other than the user can login and that is it. The 2nd row shows the PRIVILEGES for the db from the GRANT cmd.

View user in mysql.user:

enter image description here

Concerning the above picture,

select user,host,password from mysql.user where user="jeffrey123z";

select user,host,authentication_string from mysql.user where user="jeffrey123z";

The first query above is for prior to MySQL 5.7. The second query is for 5.7 and after. The password is hashed. The host is the wildcard % meaning login from any host.

More Related Contents:

  1. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  2. MySQL: How to reset or change the MySQL root password?
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. Remote Connections Mysql Ubuntu
  5. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  6. Install MySQL on Ubuntu without a password prompt
  7. How to insert BLOB and CLOB files in MySQL?
  8. Removing MySQL 5.7 Completely [closed]
  9. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  10. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ (2)
  11. How to use IN & NOT IN same query [closed]
  12. SQL Print the name of all Employees together with the name of their supervisor
  13. MySQL: Large VARCHAR vs. TEXT?
  14. Multiple-column foreign key in MySQL?
  15. mysql – making a mechanism similar to Oracle’s seqences
  16. Get the latest date from grouped MySQL data
  17. UUID performance in MySQL?
  18. MySQL: NULL vs “”
  19. MySQL Error 1264: out of range value for column
  20. Like Case Sensitive in MySQL
  21. What is the best way to delete old rows from MySQL on a rolling basis?
  22. What are the known ways to store a tree structure in a relational DB? [closed]
  23. Illegal mix of collations error in MySql
  24. mysql equivalent data types
  25. Get difference in years between two dates in MySQL as an integer
  26. Check if a column exists in a table with MySQL
  27. Connect to Docker MySQL container from localhost?
  28. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  29. Incorrect key file for table ‘/tmp/#sql_3c51_0.MYI’; try to repair it [duplicate]
  30. MySQL Relationships

Leave a Comment