Using % for host when creating a MySQL user

by

localhost is special in MySQL, it means a connection over a UNIX socket (or named pipes on Windows, I believe) as opposed to a TCP/IP socket. Using % as the host does not include localhost, hence the need to explicitly specify it.

More Related Contents:

  1. MySQL how to fill missing dates in range?
  2. How can i optimize MySQL’s ORDER BY RAND() function?
  3. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  4. Why does MYSQL higher LIMIT offset slow the query down?
  5. How to split the name string in mysql?
  6. Normalization in MYSQL
  7. Is there a REAL performance difference between INT and VARCHAR primary keys?
  8. How to set a maximum execution time for a mysql query?
  9. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  10. SQL keys, MUL vs PRI vs UNI
  11. Getting around MySQL “Can’t reopen table” error
  12. Can’t Create Entity Data Model – using MySql and EF6
  13. In MySQL, can I copy one row to insert into the same table?
  14. How to copy a row and insert in same table with a autoincrement field in MySQL?
  15. MySQL: Cloning a MySQL database on the same MySql instance
  16. MySQL sharding approaches?
  17. How to move columns in a MySQL table?
  18. access denied for load data infile in MySQL
  19. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  20. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  21. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  22. Optimization of MySQL search using “like” and wildcards
  23. Does Order of Fields of Multi-Column Index in MySQL Matter
  24. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  25. NodeJS MySQL Dump
  26. Rank() over Partition by in mysql
  27. Automatic Rollback if COMMIT TRANSACTION is not reached
  28. MySQL cartesian product between two SELECT statements
  29. Sum until certain point – MySql
  30. Speeding up mysql dumps and imports [closed]

Leave a Comment