下载下来:
-rw-r--r-- 1 root root 7635229 Jul 30 07:38 MySQL-client-community-5.1.49-1.rhel5.i386.rpm
-rw-r--r-- 1 root root 21277185 Jul 30 07:38 MySQL-server-community-5.1.49-1.rhel5.i386.rpm
动工了:
[root@localhost software]# rpm -ivh MySQL-server-community-5.1.49-1.rhel5.i386.rpm
[root@localhost software]# rpm -ivh MySQL-client-community-5.1.49-1.rhel5.i386.rpm
启动:
[root@localhost software]# /etc/init.d/mysql start
Starting MySQL [ OK ]
重启:
[root@localhost software]# /etc/init.d/mysql restart
Shutting down MySQL.... [ OK ]
Starting MySQL. [ OK ]
关掉:
[root@localhost software]# /usr/bin/mysqladmin -u root -p shutdown
Enter password:
登录授权:
[root@localhost software]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.49-community MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'lake'@'%'IDENTIFIED BY 'lake' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
[root@localhost software]# mysql -ulake -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.49-community MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
远程登录(再执行一次授权):
mysql> GRANT ALL PRIVILEGES ON *.* TO 'lake'@'%'IDENTIFIED BY 'lake' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> Ctrl-C -- exit!
[root@localhost software]# mysql -u lake -h 192.168.116.129 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.49-community MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
开放端口:
[root@localhost software]# vim /etc/sysconfig/iptable
有没有看到:
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
这就是开放22端口
意思意思:
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
修改密码:
mysql> update user set password = PASSWORD("12345") where user='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 3 Changed: 0 Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
[root@localhost software]# /etc/init.d/mysql restart
Shutting down MySQL.. [ OK ]
Starting MySQL. [ OK ]
好像还有些什么,忘记,以后再补
分享到:
相关推荐
greenplum数据库下载安装包,版本为:greenplum-db-5.10.2-rhel6-x86_64
CentOS 7.9版本(CentOS-Userland-7-armv7hl-generic-KDE-2009-sda.raw)适用于ARM32 (armhfp),必须集齐2个文件才能一起解压缩使用,2个文件下载地址: CentOS-Userland-7-armv7hl-generic-KDE-2009-sda.raw.part2...
解决vm8.0中安装rhe5.5后出现乱码的解决过程,分有点多了,这是我好不容易下载的。请大家谅解,不过知识是无价的,想解决类似问题你就下载吧。
1、包含了安装程序+分析的excel 2、使用,这里以redhat为例 输入./nmon_x86_rhe15 3、自动收集 ./nmon_x86_rhe15 -fT -s 10 -c 120 -f代表输出文件,-T最消耗资源的进程,-s收集数据的时间间隔,-c收集次数 4...
USkin是一套用于换肤的sdk,目前还在不断完善阶段,最终目标是提供对个人免费的换肤软件,
认识Samba Samba的核心是两个守护进程,即smbd和nmbd。服务器启动到停止期间持续运行,smba监听139TCP端口;...一、安装配置Samba的RPM包(包名)samba-common:包括Samba服务器和客户端均需要的文件samba:服务器
本文介绍 RHE5中搭建DNS服务器的方法,供大家学习参考
ibm_dd_sraidmr_00.00.04.38-01_rhel5_32-64.tgz
redhat6.9 iso文件 txt文件中是百度网盘的链接和提取码
派特莱RHE 系列小型LED旋转报警灯2D CADdxf,特点:小型LED旋转灯,使用单片LED与特殊构造反射系统,实现大范围的反射效果。RHEB/RKEB系列可内藏蜂鸣器(1米处90分贝),旋转的同时可发出报警声。采用优质小型马达,...
本文介绍RHE5下ftp服务器的搭建方法,供大家学习参考
上班的时候刚好老板要我写一个RHEL 5安装详细SOP给新人参考,顺便就放上来好了。内有详细截图。
rhe8的外网ping通设置.txt
n=1/RHe=9.24E14/cm-3。 =0.0473(S/m); =3.198(cm2/Vs)。 思考题: 1、若磁场不恰好与霍尔元件片底法线一致,对测量结果有何影响,如果用实验方法判断B与元件发现是否一致? 答:若磁场方向与法线不一致,载流子不但...
Perhaps I could ask those who read this editorial a rhe- torical question. When did you last fully read the Introduc- tion to a scientific paper in which you were interested? I suspect the answer ...
React排序搜索表 丰满的 可搜寻的 可排序 寻呼机包括 使用自定义组件渲染特定的TD React> = 16.8.2 react-dom> = 16.8.2 现场演示 现场演示: : 例子 需要更多示例吗?... _id : "d-rhe-428-j
文件解压后,将RHE-GPSD.pyc文件放到/home/pi/Documents子目录里,将GPST.desktop文件放到树莓派桌面上,双击GPST图标即可运行,当程序窗体的时间显示变为蓝色时,时间同步,时间显示变为绿色时,时间和定位全部完成...
安装:直接安装或者杆式安装,另配有各类安装支架可选件。可自由变换的LED模块,即使安装后改变模块排列或增加模块也无需重新接线。灯罩由耐热抗冲击半透明的AS树脂制成。NPN/PNP兼容:适用于DC24V类型,高压规格仅...