MySql 091214: Install (1/2)

@ http://zcatt.cublog.cn

Prepare

MySql 5.1.39

 

1.    Install on Linux

MySQL-server-VERSION.glibc23.i386.rpm   the MySQL server

MySQL-client-XXXXXXX.rpm   the client programs

MySQL-devel-XXXX.rpm    libraries and include files

MySQL-shared-XXXXX.rpm   the shared libraries(libmysqlclient.so*) that certain languages and app need to dynam load and use MySQL. Signle-thread and thread-safe libraries. if install this, do not install MySQL-shared-compat-XXXX.rpm

MySQL-shared-compat-XXXXX.rpm  shared libraries for ver 3.23, 4.0 and so on.

MySQL-XXXXX.src.rpm    src code

 

1) data is palced under the /var/lib/mysql directory

2) user mysql and group mysql are created to use for running the MySQL server

3) /etc/init.d in which mysql entries are created to start the server automatically

4) the grant tables are set up by the mysql_install_db program.

5) you should assign passwords to the accounts created by mysql_install_db

 

Shell> mysql_install_db –user=mysql [--basedir=….  –datadir=….]

 

Make shure that the db directories and files are owned by the mysql login account so that the server has read and write access to them. To ensure this, the –user option should be used as shown if you run mysql_install_db as root.

 

mysql_install_db creates several tables, including user, db, host, tables_priv, columns_priv, func, and others.

 

启动

shell> mysql_safe –-user=mysql &

 

关闭

shell> mysql_safe –u root shutdown

 

2.Starting and Stopping Automatically

1) msyql.server

shell> mysql.server start

shell> mysql.server stop

 

mysql.server is copied to /etc/init.d directory with the name mysql, and made executable.

2) mysqld directly

3. Securing the initial MySQL Account

You should assign password to root account,  and password to anonymous account or delete anonymous account.