fedora8 下mysql 安装的安装方法
<p>我下载的是目前最新的版本mysql-5.0.45-linux-i686.tar.gz<br /> <a class="UBBWordLink" href="#" target="_blank">安装</a>过程：<br /> su 到root 权限。<br /> #tar -zvxf mysql-5.0.45-linux-i686.tar.gz<br /> #mv mysql-5.0.45/ /usr/local/mysql<br /> #cd /usr/local/mysql<br /> #groupadd mysql<br /> #useradd -g mysql mysql<br /> #chown -R mysql .<br /> #chgrp -R mysql .<br /> #scripts/mysql_install_db --user=mysql<br /> #chown -R root .<br /> #chown -R mysql data<br /> #bin/mysqld_safe --user=mysql &<br /> 按照官方文档说这就应该能启动了，可是报错如下：<br /> <br /> <br />nohup: ignoring input and redirecting stderr to stdout<br />Starting mysqld daemon with databases from /var/lib/mysql<br />STOPPING server from pid file /var/run/mysqld/mysqld.pid<br />071112 00:22:06 mysqld ended</p><p><br />查看日志：</p>
<p>＃less /var/log/mysqld.log<br />其中有一段如下：<br />071112 0:22:06 /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)<br />071112 0:22:06 Can't start server: can't create PID file: No such file or directory<br />071112 00:22:06 mysqld ended</p>
<p>#cd /var/run/<br />#ls<br />mysqld目录不存在<br />#mkdir /var/run/mysqld<br />#cd /var/run/mysqld<br />创建文件mysqld.pid<br />#touch mysqld.pid<br />#cd..<br />#chown -R mysql mysqld .</p>
<p>#cd /usr/local/mysql/<br />#bin/mysqld_safe --user=mysql &<br />nohup: ignoring input and redirecting stderr to stdout<br />Starting mysqld daemon with databases from /var/lib/mysql</p>
<p>能正常启动</p>
<p>#bin/mysqladmin -u-root password root</p>
<p>又出错</p>
<p># bin/mysqladmin -u-root password root<br />bin/mysqladmin: connect to server at 'localhost' failed<br />error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'<br />Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!</p>
<p><br /># bin/mysql -u-root -p<br />Enter password:<br />ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)</p>
<p>分析：是/tmp/mysql.sock 不存在<br /># cd /var/lib/mysql/<br />ibdata1 ib_logfile0 ib_logfile1 mysql/ mysql.sock test/<br />由于mysql 默认的mysql.sock 是在/var/lib/mysql/mysql.sock,</p>
<p>创建符号连接：<br /># ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock<br /># bin/mysql -u-root<br />Welcome to the MySQL monitor. Commands end with ; or \g.<br />Your MySQL connection id is 1<br />Server version: 5.0.45 MySQL Community Server (GPL)</p>
<p>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.</p>
<p>mysql></p>
<p>修改root 密码<br />#cd /usr/local/mysql/<br />#bin/mysqladmin -u-root -p password yourpassword</p>
<p>一切ok.<br />一切ok...</p>
頁:
[1]