MySql 091214
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.rpmshared 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
页:
[1]