MySql 091214

fang.zhang

  Normal
  0
  
  7.8 磅
  0
  2
  
  false
  false
  false
  
   
   
   
   
   
   
   
   
   
   
   
   
  
  MicrosoftInternetExplorer4



st1\:*{behavior:url(#ieooui) }
/* Style Definitions */
table.MsoNormalTable
        {mso-style-name:普通表格;
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        mso-style-noshow:yes;
        mso-style-parent:"";
        mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
        mso-para-margin:0cm;
        mso-para-margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:10.0pt;
        font-family:"Times New Roman";
        mso-ansi-language:#0400;
        mso-fareast-language:#0400;
        mso-bidi-language:#0400;}
table.MsoTableGrid
        {mso-style-name:网格型;
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        border:solid windowtext 1.0pt;
        mso-border-alt:solid windowtext .5pt;
        mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
        mso-border-insideh:.5pt solid windowtext;
        mso-border-insidev:.5pt solid windowtext;
        mso-para-margin:0cm;
        mso-para-margin-bottom:.0001pt;
        text-align:justify;
        text-justify:inter-ideograph;
        mso-pagination:none;
        font-size:10.0pt;
        font-family:"Times New Roman";
        mso-ansi-language:#0400;
        mso-fareast-language:#0400;
        mso-bidi-language:#0400;}
MySql 091214

  Normal
  0
  
  7.8 磅
  0
  2
  
  false
  false
  false
  
   
   
   
   
   
   
   
   
   
   
   
   
  
  MicrosoftInternetExplorer4



/* Style Definitions */
table.MsoNormalTable
        {mso-style-name:普通表格;
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        mso-style-noshow:yes;
        mso-style-parent:"";
        mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
        mso-para-margin:0cm;
        mso-para-margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:10.0pt;
        font-family:"Times New Roman";
        mso-ansi-language:#0400;
        mso-fareast-language:#0400;
        mso-bidi-language:#0400;}
@ 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.
               
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/8866/showart_2121120.html