linux下安装mysql - Linux & Advanced Application - 51CTO技术论坛

社区导航: 专家门诊网络技术操作系统数据库程序设计系统应用考试认证 CIO及信息化站长交流综合交流下载基地 51CTO产品服务

【设为首页 | 收藏本站】

51CTO技术论坛» Linux & Advanced Application » linux下安装mysql [ 打印] [ 订阅] [ 收藏] [ 推荐给朋友] [ 本帖文本页]

论坛跳转:

408240786
新新人类

帖子 12
精华 0
无忧币 19
积分 24
阅读权限 20

注册日期 2008-3-24

最后登录 2008-10-8

离线

[查看资料] [发短消息] [Blog]

发表于:2008-6-22 17:43　　标题：linux下安装mysql
＜上一帖 | 下一帖＞

mysql版本为4.1.18
首先下载到root目录下然后接下去就是解压
#tar zxvf mysql-4.1.18.tar.gz
#cd  mysql-4.1.18
#./configure --prefix=/usr/local/mysql --with-charset=gb2312  --with-extra-charsets=all  #--prefix指定安装目录，让他支持中文，支持所有语言
#make
#make install
#make clean
#cp /root/mysql-4.1.18/support-files/my-huge.cnf.sh /etc/my.cnf #根据自己主机的情况复制my-*.cnf的一个，huge是应用于内存在2G以上的情况.
#vi /etc/mysql.cnf
port          = 3306
socket       = /tmp/mysql.sock  （修改这2个地方）
#groupadd mysql
#useradd -g mysql mysql （第一个mysql是组，第二个mysql是用户）
#cd /usr/local/mysql
#bin/mysql_install_db --user=mysql #建立基本数据库，必须指明为mysql用户,只有这一步才能在usr/local/mysql下出现var目录。出现如下：
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
Unknown suffix [url=mailto:'@']'@'[/url] used for variable 'port' (value [url=mailto:'@MYSQL_TCP_PORT@']'@MYSQL_TCP_PORT@'[/url])
080425  4:38:40 /usr/local/mysql/libexec/mysqld: Error while setting value [url=mailto:'@MYSQL_TCP_PORT@']'@MYSQL_TCP_PORT@'[/url] to 'port'
Installation of grant tables failed!
Examine the logs in /usr/local/mysql/var for more information.
You can also try to start the mysqld daemon with:
/usr/local/mysql/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/local/mysql/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/var that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script!

# bin/mysqld_safe --user=mysql &  #出现如下提示：
[1] 23095
[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
###这样就停在这边，就是正常启动。如果想确认用下面命令
# ps -aux |grep mysql
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
root    23095  0.1  0.2  4408 1084 pts/1 S 04:44 0:00 /bin/sh bin/mysqld_safe --user=mysql
mysql 23118  3.1  2.4 114464 12676 pts/1  Sl 04:44 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock
root    23128  0.0  0.1  5524  640 pts/1 R+ 04:44 0:00 grep mysql
###这样表示正常启动
#bin/mysqladmin -uroot password 123456 (设置mysql的root密码为123456，默认是空的)
## bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.25-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
#bin/mysqld_safe &或/usr/local/mysql/share/mysql/mysql.server start 启动mysql
#/usr/local/mysql/share/mysql/mysql.server stop 停止mysql
#ps -aux|grep mysql查看进程
#kill id号 ----这是杀mysql进程的，id号是在查看mysql进程里面看的到。