rpm软件安装:
查看安装软件:rpm -qa|grep -i jdk
卸载软件:rpm -e jdk-1.6.0_03-fcs
安装软件:rpm -ivh jdk-6u3-linux-i586.rpm --nodeps
1.下载mysql的rpm包
2.rpm –ivh MySQL-server-5.6.12-2.rhel5.i386.rpm --nodeps
注意:因为在安装时,经常会出错提示缺少依赖包!所以需要加上--nodeps参数强制安装
3.查看mysql是否已经启动:ps -ef|grep mysql
root 3523 1 0 22:02 pts/2 00:00:00 /bin/sh/usr/bin/mysqld_safe--datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --user=mysql
mysql 3573 3523 6 22:02 pts/2 00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock
4.启动和停止mysql服务
启动方法1:service mysqld start
启动方法2:/etc/init.d/mysql start
停止: /usr/bin/mysqladmin -u root -p shutdown
5.重置数据库root的密码
格式:/usr/bin/mysqladmin -u 用户名 -p 旧密码 password 新密码
如:/usr/bin/mysqladmin -u root password 123456 【 注:因为开始时root没有密码,所以-p旧密码一项就可以省略了。】
6.登陆mysql服务器:mysql -u root -p
【6.1】mysql随机生成的密码:more /root/.mysql_secret ,在安装时有提示
【6.2】第一次登陆成功后,输入如下的的语句,判断当前密码是否有效,如果没效的话,则将密码重新设置
mysql>show databases;
出现ERROR 1820 (HY000): You must SET PASSWORD before executing this statement,要将密码重新设置:
mysql> SET PASSWORD = PASSWORD('123456');
mysql> flush privileges;
7:添加mysql的用户
登录mysql,添加mysql用户 :grant 权限 on 数据库名.表名 用户@登录主机 identified by "用户密码";
如:添加testB,容许远程【"%"】登录,密码为"123456"
GRANT ALL PRIVILEGES ON *.* TO testB@"%" IDENTIFIED BY '123456' WITH GRANT OPTION;
新建用户和分配权限时,出现如下的异常,[要在linux界面重新输入字符串间的空格]:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TO admin@"%" IDENTIFIED BY 'admin' WITH GRANT OPTION' at line 1
8.在windows下,通过mysql的客户端navicate连接mysql服务器
9:设置开机启动: chkconfigmysqld on
10:删除已存在的mysql:rm -rf /usr/lib/mysql/ 和rm -rf /usr/share/mysql
原文:http://blog.csdn.net/love__coder/article/details/6894566
参考文章:http://rq2-79.iteye.com/blog/175869和http://www.cnblogs.com/jdonson/archive/2010/05/21/1740786.html和http://os.51cto.com/art/201301/377515.htm,mysql密码修改:http://www.111cn.net/database/mysql/45605.htm