How to grant remote access permissions to mysql server for user?

If I do SHOW GRANTS in my mysql database I get

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' 
    IDENTIFIED BY PASSWORD 'some_characters' 
    WITH GRANT OPTION

If I am not mistaken, root@localhost means that user root can access the server only from localhost. How do I tell MySQL to grant root the permission to access this mysql server from every other machine (in the same network), too?

Related Posts:

  1. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  4. MySQL Error “Operand should contain 1 column”
  5. How to use MySQL DECIMAL?
  6. MySQL ERROR 1290 (HY000) –secure-file-priv option
  7. MySQL server startup error ‘The server quit without updating PID file’
  8. MySQL DROP all tables, ignoring foreign keys
  9. Duplicating a MySQL table, indices, and data
  10. mysql Foreign key constraint is incorrectly formed error
  11. mysql is not recognised as an internal or external command,operable program or batch
  12. SELECT * FROM multiple tables. MySQL
  13. mysql: SOURCE error 2?
  14. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  15. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  16. Data truncated for column?
  17. MySQL foreach loop
  18. MySQL IF NOT NULL, then display 1, else display 0
  19. MySQL date format DD/MM/YYYY select query?
  20. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  21. MySQL Calculate Percentage
  22. Repair all tables in one go
  23. Error: select command denied to user ‘‘@’‘ for table ‘‘
  24. MySQL: What’s the difference between float and double?
  25. How can I search (case-insensitive) in a column using LIKE wildcard?
  26. #1214 – The used table type doesn’t support FULLTEXT indexes
  27. importing a CSV into phpmyadmin
  28. How can I rebuild indexes and update stats in MySQL innoDB?
  29. MySQL Error 1215: Cannot add foreign key constraint
  30. How to unblock with mysqladmin flush hosts
  31. Node.js MySQL – Error: connect ECONNREFUSED
  32. How to use the keyword ‘references’ in MySQL?
  33. select * from table where column = something or, when unavailable, column = something else
  34. Differences between utf8 and latin1
  35. There can be only one auto column
  36. What are the recommended database permissions for WordPress?
  37. What’s a good strategy for planning WordPress DB growth?
  38. How can I find the source of slow queries in WordPress?
  39. $wpdb and MySQL Create Trigger
  40. Ordering posts by day (not time) AND meta value
  41. Problems with DBDelta with FOREIGN key?
  42. Fulltext search in posts sorted by relevancy
  43. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  44. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  45. How can I make wordpress suppress mysql errors?
  46. How to bulk delete all WordPress subscribers?
  47. Error while importing database
  48. What are the issues associated with upgrading MySQL for WordPress?
  49. Changing Table Prefix for an Existing WordPresss Site
  50. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  51. Connect another DB and fetch records from some tables
  52. Can I restart MySQL engine when WordPress website is live?
  53. Error: MySQL shutdown unexpectedly [closed]
  54. #1115 – Unknown character set: ‘utf8mb4’
  55. Why my wordpress loopback traffic while socket is setup?
  56. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  57. Update or insert meta key value – On Duplicate key update
  58. Connect to MySQL using Windows Authentication
  59. Defining the same price to all WooCommerce Products
  60. Database Structure on Different Servers
  61. Changing MySQL password via WHM – does this affect WordPress?
  62. How to get INSERT errors from $wpdb?
  63. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  64. Export Yoast Keywords from MySQL/phpMyAdmin
  65. Same database; different WordPress
  66. How to insert dash (-) into database using wpdb and new_to_publish hook?
  67. MySQL: How to change url in posts from xxx.com to yyy.org?
  68. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  69. WordPress unescape text on mysql?
  70. Getting data from Mysql Table..confusing
  71. Upgrade DB Loop – WordPress DB Version Conflict
  72. WordPress & MySQL , problem with use many array in meta_query
  73. mysql – Delete keyword with link from wordpress post database
  74. Creating dynamic content and pages for 1000’s of locations
  75. Button writing to MYSQL database
  76. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  77. DB option update with wp-cli
  78. MySQL ‘duplicate entry’ error
  79. WordPress Dutch characters encoding problem
  80. How to show result of sql query in a page?
  81. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  82. 403 Forbidden home on localhost with nginx server
  83. How do I insert content of various MySQL fields in post?
  84. Select latest 2 articles, but only from given category
  85. CONCAT_WS in custom sql query
  86. Query does not filter duplicate _sku numbers
  87. Ordering topics by most replies in X days using MYSQL statement
  88. MySQL Select within WP Page template
  89. #1115 – Unknown character set: ‘utf8mb4’
  90. wp_postmeta – lot of meta fields
  91. Running WordPress from MySQL Cluster with HAPRoxy
  92. Delete posts with word count less than x number of words
  93. MySQL: get post_tag items that are tags (not SEO keywords)
  94. $wpdb->get_var returns 0
  95. cannot log in to the mysql server (wamp and wordpress)
  96. SQL command to export post_content from wp_posts using phpMyAdmin
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database

Leave a Comment