How to configure the MySQL database in Linux

The following article describes how to install and configure a MySQL database in a Linux operating system. We all know that many websites currently use Linux + MySql. Installing and configuring MySql in Windows is simple.

But it is a little troublesome to install it in Linux. For Linux beginners who are familiar with Windows, it is really "quite" troublesome!

Follow these steps to install MySql in Red Hat Enterprise Linux AS 4.0:

Download MySQL:

Download Red Hat Enterprise Linux 4 RPM (x86): MySQL-server-standard-5.0.27-0.rhel4.i386.rpm

Install MySQL:

 
 

  
  
rpm -ivh MySQL-server-standard-5.0.27-0.rhel4.i386.rpm --nodeps --force 
 
 

Modify/etc/my. cnf as needed. Refer to configuring MySQL:

 
 

  
  
[mysqld] 
 
 

The default setting is an INNODB table, which supports transactions and row locks:

 
 

  
  
default-storage-engine=INNODB 
 
 

Set the default character set:

 
 

  
  
default-character-set=utf8 
 
 

Maximum buffer size used for client communication

 
 

  
  
max_allowed_packet=16M 
 
 

Start MySQL:

 
 

  
  
service mysql start  
  
  
/etc/init.d/mysql start  
  
  
/usr/share/mysql/mysql.server start 
 
 

[Mysql. server]

# Comment out the basedir line; otherwise, MySql may not be able to start

# It is said to be a MySql bug

 
 

  
  
# basedir=/var/lib 
 
 

Enable MySQL to start automatically when the MySql system is started: Check MySQL in system Settings> Server Settings> service.

When the root user logs on, mysql is automatically started:

Add one line to the/root/. bash_profile file:

 
 

  
  
/usr/share/mysql/mysql.server start 
 
 

View the startup log:

 
 

  
  
/var/log/messages 
 
 

Show all MySQL users:

 
 

  
  
use mysql;  
  
  
select host,user,password from user; 
 
 

Add a MySQL user (user name: user1, password: SQL ):

 
 

  
  
grant all on *.* to user1@'%' identified by 'sql' with grant option; 
 
 

Delete a MySQL user:

 
 

  
  
delete from user where user='user1'; 
 
 

The above content is an introduction to installing and configuring MySQL in Linux. I hope you will have some gains.