connecting to mysql server on another PC in LAN

by

That was a very useful question! Since we need to run the application with a centralized database, we should give the privileges to that computer in LAN to access the particular database hosted in LAN PC. Here is the solution for that!

  1. Go to MySQL server
  2. Type the following code to grant access for other pc: 
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root_password';
  3. then type: 
    FLUSH PRIVILEGES;

Replace % with the IP you want to grant access for!

More Related Contents:

  1. NOT LIKE not working with SHOW [duplicate]
  2. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  3. How to define a custom ORDER BY order in mySQL
  4. MySQL update table based on another tables value
  5. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  6. On Duplicate Key Update same as insert
  7. How to get the number of days of difference between two dates on MySQL?
  8. Ordering by the order of values in a SQL IN() clause
  9. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  10. conditional join in mysql
  11. How to export and import a .sql file from command line with options? [duplicate]
  12. a count for each join – optimisation
  13. How to grant all privileges to root user in MySQL 8.0
  14. MySQL Group by SUM
  15. The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
  16. Search for all occurrences of a string in a mysql database [duplicate]
  17. How to add not null constraint to existing column in MySQL
  18. How to reset the root password in MySQL 8.0.11?
  19. What characters have to be escaped to prevent (My)SQL injections?
  20. Is there any performance gain in indexing a boolean field?
  21. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  22. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  23. How to swap values of two rows in MySQL without violating unique constraint?
  24. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  25. Storing images in MySQL [closed]
  26. Would it help to add index to BIGINT column in MySQL?
  27. Query to count the number of tables I have in MySQL
  28. `MODIFY COLUMN` vs `CHANGE COLUMN`
  29. INSERT INTO Table from multiple tables
  30. Counting associated entries with Sequelize

Leave a Comment