mysql5.1.61编译-安装

《mysql5.1.61编译-安装》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、Mysql5.1.61tarinstall2012年10月31日16:23  [root@localhost]#groupaddmysql  [root@localhost]#useraddmysql-gmysql-M   [root@localhost]#mkdir-p/usr/local/mysql                   chown-Rroot:mysql/usr/local/mysql  [root@localhost]#./configure--prefix=/usr/local/mysql--

2、with-charset=utf8 --with-extra-character=all --with-collation=utf8_general_ci --localstatedir=/usr/local/mysql/data--with-plugins=partition,innobase,myisammrg  [root@localhost]#make  [root@localhost]#makeinstall2mysql数据库初始化  [root@localhost]#cpsupport-files/my-

3、medium.cnf/etc/my.cnf           源码包路径中  [root@localhost]#cpsupport-files/mysql.server/etc/init.d/mysqld    安装目录下share下也有 [root@localhost]#chmod700/etc/init.d/mysqld [root@localhost]#vim/root/mysql/scripts/mysql_install_db将/usr/local/mysql改为prefix中定义的目录。MySQL的库文

4、件路径“/usr/local/mysql/lib/mysql” 加入到系统的库文件搜索路径中echo /usr/local/mysql/lib/mysql>>/etc/ld.so.conf ldconfig  chown-Rmysql:mysql/var/lib/mysql[root@localhost]#   ./usr/local/mysql/bin/mysql_install_db--user=mysql [root@localhost]# ./usr/local/mysql/bin/mysqld_safe--

5、user=mysql&              ExportPATH=/usr/local/mysql:$PATH                echoexport/usr/local/mysql/bin>>/etc/profile     source/etc/profile[root@localhost]#mysql–uroot–p回车即可登录  chkconfig--addmysqld chkconfig--addmysqld   为了安全，册除本机匿名连接的其他用户mysql>usemysql;mysql

6、>deletefromuserwherepassword='';//删除用于本机匿名连接的空密码帐号mysql>flushprivileges;mysql>quit 查看mysql版本mysql-v或者mysql>statusshowvariables 查看mysql参数修改默认字符集最简单的修改方法，就是修改mysql的my.cnf文件中的字符集键值，如default-character-set=utf8 开启远程访问权限GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY

7、'youpassword'WITHGRANTOPTION; 源文档GRANTALLON*.*TOroot@'%'IDENTIFIEDBY'';  *.*所有库中所有表    %所有IP地址可以登录  本机登录不需要密码flushprivileges;