Linux configuration MySQL case-sensitive (without distinguishing between possible tables found) how to use Yum to install MySQL

Linux By default, databases are case-sensitive, so to set MySQL to be case insensitive

In MY.COF settings Lower_case_table_names=1 (1 ignoring case, 0 case-sensitive)

Check mode: Enter the following command in the MySQL console

Show variables like ' lower% ';

Find MySQL installation path under Linux:

Whereis MySQL

Yum installs MySQL:

Linux uses yum to install MySQL, as well as start, login, and remote access. 1, installation view has been installed: Yum list installed MySQL*rpm-qa | grep mysql*See if there are any installation packages: Yum list MySQL*install MySQL client: Yum install MySQL installation mysql server side: Yum install MySQL-server yum install MySQL-devel2. Start &&Stop database Character set MySQL configuration fileAdd default-character-set= in/ETC/MY.CNFUTF8 start MySQL services: Service mysqld start or/etc/init.d/mysqld start boot: chkconfig-add mysqld, check if boot boot settings are successful chkconfig--list | grep mysql*mysqld 0: Off1: Off 2: Enable 3: Enable 4: Enable 5: Enable 6: Shutdown STOP: Service mysqld stop3, login Create root administrator: Mysqladmin-U root Password 123456Login: MySQL-U Root-p Enter the password. Forgot Password: Service mysqld stop Mysqld_safe--user=root--skip-grant-tables MySQL-u root use MySQL update user set password=password ("New_pass") Where user="Root";   Flush privileges; 4, remote access to the port number of the open firewall MySQL add permission: The user table in the MySQL library adds a record with the host as "%", User is" root ". 5, several important directory database directories for Linux MySQL/var/lib/mysql/configuration file/usr/share/MySQL (mysql.server command and configuration file) related commands/usr/bin (mysqladmin mysqldump, etc command) startup script/etc/rc.d/init.d/(startup script file for MySQL directory)

Linux configuration MySQL case-sensitive (without distinguishing between possible tables found) how to use Yum to install MySQL