Linux下卸载MySQL1、查找以前是否装有MySQL命令:rpm -qa|grep -i MySQL可以看到MySQL的两个包:MySQL-4.1.12-3.RHEL4.1MySQLclient10-3.23.58-4.RHEL4.12、删除MySQL删除命令:rpm -e --nodeps 包名 ( rpm -ev MySQL-4.1.12-3.RHEL4.1 )3、删除老版本MySQL的开发头文件和库命令:rm -fr /usr/lib/MySQL rm -fr /usr/include/MySQL 注意:卸载后/var/lib/MySQL中的数据及/etc/my.cnf不会删除,如果确定没用后就手工删除rm -f /etc/my.cnf rm -fr /var/lib/MySQL
安装MySQL安装前准备:两个rpm包MySQL-client-5.1.20-0.glibc23.i386.rpmMySQL-server-5.1.20-0.glibc23.i386.rpm1、安装服务端:命令:rpm -ivh MySQL-server-5.1.20-0.glibc23.i386.rpm安装成功会出现....warning: MySQL-server-5.1.20-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5Preparing... ########################################### [100%]1:MySQL-server ########################################### [100%]080220 13:58:27 [Note] Plugin "InnoDB" disabled by command line option080220 13:58:28 [Note] Plugin "InnoDB" disabled by command line optionPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/bin/MySQLadmin -u root password "new-password"/usr/bin/MySQLadmin -u root -h localhost.localdomain password "new-password"See the manual for more instructions.Please report any problems with the /usr/bin/MySQLbug script!The latest information about MySQL is available on the web athttp://www.MySQL.comSupport MySQL by buying support/licenses at http://shop.MySQL.comStarting MySQL.[ OK ]2、安装客户端命令:rpm -ivh MySQL-client-5.1.20-0.glibc23.i386.rpm 成功表现:[root@localhost ~]# rpm -ivh MySQL-client-5.1.20-0.glibc23.i386.rpm warning: MySQL-client-5.1.20-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5Preparing... ########################################### [100%]1:MySQL-client ########################################### [100%]3、登陆MySQL登陆MySQL的命令是MySQL,MySQL 的使用语法如下:MySQL [-u username] [-h host] [-p[password]] [dbname]username 与 password 分别是 MySQL 的用户名与密码,MySQL的初始管理帐号是root,没有密码,注意:这个root用户不是Linux的系统用户。MySQL默认用户是root,由于初始没有密码,第一次进时只需键入MySQL即可[root@localhost ~]# MySQLWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 2Server version: 5.1.20-beta MySQL Community Server (GPL)Type "help;" or "h" for help. Type "c" to clear the buffer.MySQL>出现了“MySQL>”提示符,恭喜你,安装成功! 增加了密码后的登录格式如下: MySQL -u root -p Enter password: (输入密码) 其中-u后跟的是用户名,-p要求输入密码,回车后在输入密码处输入密码。 注意:这个MySQL文件在/usr/bin目录下,与后面讲的启动文件/etc/init.d/MySQL不是一个文件。 补: 通过rpm包安装、配置及卸载MySQL的详细过程. 以MySQL-server-4.0.14-0.i386.rpm为例,放在/data目录下 cd /data rpm -ivh MySQL-server-4.0.14-0.i386.rpm 安装完成后在/usr/share/MySQL目录中会有一个MySQL的启动脚本MySQL.server及示例配置文件等(如my-huge.cnf、my-large.cnf、my-medium.cnf) 拷贝一个示例配置文件作为MySQL的配置文件: cp /usr/share/MySQL/my-medium.cnf /etc/my.cnf rpm包安装完后自动将MySQL安装成系统服务,所以可以使用下面命令启动、停止MySQL
Linux_7:LAMP再次安装遇到的问题及解决办法Solaris操作系统下安装MySQL5札记相关资讯 linux mysql
- Linux下MySQL的简单操作笔记 (08/12/2015 10:50:28)
- Linux下MySQL报Table "xxx" doesn" (11/22/2014 07:37:47)
- Linux下解决MySQL无法远程连接问题 (11/14/2013 07:18:33)
| - Linux开启MySQL远程连接 (11/22/2014 07:40:48)
- Linux系统MySQL数据库远程设置 (01/10/2014 09:35:35)
- Linux网站架构系列之MySQL----部署 (11/06/2013 20:21:28)
|
本文评论 查看全部评论 (1)