linux下安装mysql
作者 佚名技术
来源 Linux系统
浏览
发布时间 2012-05-16
| #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 #make #make install #make clean #cp /usr/local/mysql/share/mysql/my-huge.cnf /etc/my.cnf #groupadd mysql #useradd -g mysql mysql #cd /usr/local/mysql #bin/mysql_install_db --user=mysql #建立基本数据库,  指明为mysql用户,出现如下：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 ''@'' used for variable ''port'' (value ''@MYSQL_TCP_PORT@'') 080425 4:38:40 /usr/local/mysql/libexec/mysqld: Error while setting value ''@MYSQL_TCP_PORT@'' 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 [url]http://www.mysql.com[/url] 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进程里面看的到. 我们来修改一下mysql的启动的方式 |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢! |
你可能对下面的文章感兴趣
关于linux下安装mysql的所有评论
