Linux服务器搭建之六：mysql数据库服务器

1、Linux服务器搭建之六：mysql数据库服务器这个丢脸了，我没有学过SQL,没有操作过MySQL数据库，只是渗透时获取别人的数据库文 件而已。既然搭建好了就不怕献丑。Linux操作系统平台：Fedora 14 账户：root主要软件包：mysql-serverMySQL数据库服务器搭建流程：1. rpm -qa | grep mysql命令査看有关mysql的软件包，里面有个mysql-server就是 我们想要的：roottianlang rpm -qa |grep mysqlmysql-5.1.60-1.fc14.i686mysql-libs-5.1.60-1.fc14-i686mysq

2、l-server-5.1.60-1.fc14.i686ootPt伽lana F 2在 root 账户里安装 mysql-scrver 服务器：yum -y install mysql-server文件(F)编辑(E)查看(V)搜索 终端(T)帮助(H)tianlangtianlang 、$ su -密码：rootetianlang '# yum -y install mysql-server已力D载扌宙件:axelget, fastestmirror, langpacks, presto, refresh-packagekit Adding zh_CN to language list

3、Loading mirror speeds from cached hostfile* fedora： * updates： 设迓安装进程 解决依赖关系->执行爭务检查-> 软件包 mysql-server. i686 0: 5 .1. 60-1. fc14 将被 安装处理依赖关系 mysql(x86-32) = 5.1.60-1 .fc14r 它被软件包 mysql-server-5.1.60-1 .fc14.1686 需要-> 处理依赖关系 libmysqlclient.so. 1 6(libm

4、ysqlclient_16).它被软件包 mysqlsen/e r-5-1.60-1 .fc14.i68& 需要-> 处理依赖关系 libmysqlclient.r.so. 16(libmysqlclient_16)r 它被软件包 mysql-ser ver-5.1.60-1. fc14.1686 需要perVDBI,它被软件包 mysql-server-5.1.69-1.fcl4.1686 需妥 perl-DBD-MySQL,它被软件包 mysql-server-5.1.60-1. fc14.1686 需要 perl(DBI) r 它被软件包 mysql-server-5.1.

5、 60-1 .fc14. i68 6 需要 libmysqlclient.r.so. 16r 它被软件包 mysql-server-5.1.68-1 .fc14. i->处理依赖关系->处理依赖关系处理依赖关系处理依赖关系libmysqlclient.so. 16f 它被软件包 mysql-server-5.1.60-1.fc14.i&8686需要处理依赖关系3安装成功，看看吧，yum会自动安装与mysql-server软件包相关的底层类库的，非常智 能文件(F)编辑(E)查看(V)搜索(S)终端(T)帮助(H)Connection 0 finishedConnection

6、 9 finished100% 426.8KB/S 00:00Downloaded 1263.1 kilobytes in 2 seconds. (426.80 KB/s)运行 rpm_check_debug执行事务测试爭务测试成功执行事务正在安装:mysql-libs-5.1.60-1.fc14.i6861/5正在安装:perI-DBI-1.613-1.fc14.i6862/5正在安装:mysql-5.1.60-1.fc14.16863/5正在安装:perl-DBD-MySQL-4.017-1.fc14.16864/5正在安装:mysql-server-5.1.60-1.fc14.i6865

7、/5已安装：mysql-serveri686 0:5.1.60-1.fc14作为依赖被安装： mysql.i686 0:5.1.60-1.fc14mysql-Iibs.i686 0:5.1.60-1.fc14perl-DBD-MySQL. 1686 0:4.017-1 .fc14perbDBI.i686 0:1.613-1. fc14完毕！rootetianlang4开启 mysql-server 服务器吧：I service mysql startroottianlang:文件(F)编辑(E)查看(V)搜索(S)终端(T)帮助(H)root©tianlangservice mysq

8、ld startQ材始化 MySQL 数据库：Installing MySQL system tables.OKFilling help tables-OKTo start mysqld at boot time you have to copy support-files/mysqlserver to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following comm

9、ands：/usr/bin/mysqladmin -u root password 1 new-passworcf /usr/bin/mysqladmin -u root h tianlang passv/ord 1 nev/-passwordAlternatively you can run：/usr/bin/mysql_secure_installationwhich will also give you the option of removing the test databases and anonymous user created by default This is stron

10、gly recommended for production serversSee the manual for more instructions.You can start the MySQL daemon with： cd /usr ; /usr/bin/mysqldsafe &5使用【mysqladmin -u root passwd 'root'】新建数据库服务器账户: 使用【mysql u root -p登录mysql-server服务器吧:rootetianlang、# mysqladmin root passv/ord ' root*rootet

11、ianlang 、# mysql -u root pEnter password:Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 4Server version： 5.1.60 Source distributionCopyright (c) 2000, 2011, Oracle and/or its affiliates. AU rights reserved.Oracle is a registered trademark of Oracle Corporation and

12、/or its affiliates Other names may be trademarks of their respective ownersType 1 help；1 or 'Xh* for help. Type lcl to clear the current input statementmysql> j6使用【？】査看mysql提供的命令吧:mysql> ?(?)clear(C)connect(r)delimiter(d)edit(e)ego(G)exit(q)go(g)help(h)nopager(n)notee(t)pager(P)print(p)pro

13、mpt(R)quit(q)rehash(#)For information about MySQL products and services, visit: http:/ww For developer information, including the MySQL Reference Manual“ visit: http;/To buy MySQL Enterprise support； training, or other products； visit: https：/shop mysqlcom/List of dll MySQL commands:Note that all te

14、xt commands must be first on line and end withSynonym for xhelp1.Clear the current input statement.Reconnect to the server. Optional arguments are db and host. Set statement delimiterEdit command with $EDITOR.Send command to mysql server, display re&ult vertically.Exit mysql. Same as quit.Send c

15、ommand to mysql serverDisplay this helpDisable pager, print to stdoutDon1t write into outfile.Set PAGER to.pager. Print the query results via PAGER.Print current commandChange your mysql promptQuit mysql.Rebuild completion hashconnect delimiter edit ego exit go help nopager notee pager print prompt

16、quit rehash source status system tee use charset() (d) (e) (G) (q) (g) (h) (n) (t) (P) (p) (R) (q) (#) (.) (s) (!) (T) (u) (C)with multi-byte charsets warnings (V/) Show warnings after every statement nov/arning (w) Don*t show v/arnings after every statement.rdc)ttianlang:-文件(F)编辑(E)查看(V)搜索(S)终端(T)帮

17、助(H)Reconnect to the server Optional arguments are db and hostSet statement delimiterEdit command with $EDITOR.Send command to mysql server, display result vertically.Exit mysql. Same as quit.Send command to mysql serverDisplay this helpDisable pager, print to stdoutDon't write into outfileSet P

18、AGER to.pager. Print the query results via PAGER.Print current commandChange your mysql promptQuit mysqlRebuild completion hashExecute an SQL script Hie. Takes a file name as an argument.Get status information from the serverExecute a system shell commandSet outfile tooutfile Append everything into given outfileUse another database Ta