As you can see here, a UNIX mysqld uses sockets if used without a host name or with the host name localhost
.
So it makes a difference, and in the GRANT system this difference becomes evident.
More Related Contents:
- Error related to only_full_group_by when executing a query in MySql
- Find duplicate records in MySQL
- How to declare a variable in MySQL?
- Can you split/explode a field in a MySQL query?
- MySQL order by before group by
- MySQL Cannot Add Foreign Key Constraint
- Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
- Grouping into interval of 5 minutes within a time range
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
- Difference between float and decimal data type
- Parse date in MySQL
- How to escape literal percent sign when NO_BACKSLASH_ESCAPES option is enabled?
- MySQL MONTHNAME() from numbers
- Aggregate function in MySQL – list (like LISTAGG in Oracle)
- View’s SELECT contains a subquery in the FROM clause
- How to fetch the first and last record of a grouped record in a MySQL query with aggregate functions?
- MySQL incorrect key file for tmp table when making multiple joins
- How to cast DATETIME as a DATE in mysql?
- ORDER BY date and time BEFORE GROUP BY name in mysql
- Does the order of conditions in a WHERE clause affect MySQL performance?
- Difference between these two joining table approaches?
- MySQL INT meaning
- Get total number of rows when using LIMIT? [duplicate]
- Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
- MySQL export into outfile : CSV escaping chars
- Simple Random Samples from a MySQL Sql database
- MySQL Select minimum/maximum among two (or more) given values
- MySQL: Many tables or many databases?
- MySQL errorno 121
- comparison of truncate vs delete in mysql/sqlserver [duplicate]