MySQL using notes

One, query a field with multiple records and display only one row

Select  from Group  by  having Count > 1;

Second, MySQL to give other machine connection permissions

Grant  All  on *. *  to [Email protected] ' localhost '  by  Grantall on*. *  to [Email protected] ' % '  by "Root";

Third, MySQL data file

1, about My.ini profile: Before mysql5.6, my.ini configuration files, database files and MySQL installation directory are in the same directory, and after mysql5.6, my.ini configuration files, database files by default in the C-drive Programdata directory. 2, if you want to migrate the database files, can be configured in My.ini (temporarily do not know how to configure a My.ini in the installation directory to load without loading programdata my.ini files, so that you can let the My.ini configuration file, The database file and the MySQL installation directory are in the same directory).

MySQL using notes