Shulou(Shulou.com)05/31 Report--

Editor to share with you what mysql common problems are, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Can't connect to local MySQL server through socket'/ tmp/mysql.sock'

/ usr/local/mysql/bin/mysqld_safe & restart again

2./scripts/mysql_install_db. / bin/my_print_defaults: cannot execute binary file

/ scripts/mysql_install_db-user=mysql-force

3. How to tell whether MySQL is source code or binary

First look at the size, the general source code is relatively small, more than 20m, binary is generally more than 100m, download after taking a look at the file, generally have .c file is the source code version, there is a bin directory is the binary version.

4. How to view the location of the my.cnf currently used by mysql.

Under linux/unix, mysql looks for configuration file 1. 1 in the following locations in order. In the / etc/my.cnf file, the first location mysql looks for is the global options file, where the default options for all users and all servers are placed in this file. In the DATADIR/my.cnf file, DATADIR is the directory where the mysql server saves its data files. This configuration file applies only to the configuration parameter 3. 0 for a given server. Through the location specified by the-- defaults-extra-file=filename command line option, this command option enables the mysql server or client utility to look for configuration files anywhere. In the $HOME/.my.cnf file, $HOME is the unix environment variable of the current user's home directory. This only gives each user its specific option, which is where the customer option is specified.

5.mysqldump

Mysqldump-- all-databases > / usr/local/src/db236.sql-u root-p

Enter password:

Mysqldump: Got error: 1556: You can't use locks with log tables. When using LOCK TABLES

[root@localhost bin] # mysqldump-- lock-tables=0-- all-databases > / usr/local/src/db236.sql-u root-p

Enter password:

The above is all the content of the article "what are the mysql FAQs?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.