这是系统安装软件包选择:
CentOS6相对于CentOS5的安装有了不少的进步,有不少默认的选项可以选择,如:
Desktop :基本的桌面系统,包括常用的桌面软件,如文档zd查看工具。
Minimal Desktop :基本的桌面系统,包含的软件更少。
Minimal :基本的系统,不含有任何可选的软件包。
Basic Server :安装的基本系统的平台支持,不包含桌面内。
Database Server :基本系统平台,加上MySQL和PostgreSQL数据库,无桌面。
Web Server :基本系统平台,加上PHP,Web server,还有容MySQL和PostgreSQL数据库的客户端,无桌面。
Virtual Host :基本系统加虚拟平台。
Software Development Workstation :包含软件包较多,基本系统,虚拟化平台,桌面环境,开发工具。
而安装Linux基本是用来构建服务器的,所以基本上选择Basic Server OK了。
但是有时是需要图形界面的,例如,安装Oracle最好搞个图形界面。
[root@localhost Desktop]# cat /etc/redhat-release
CentOS release 6.5 (Final)
安装完以后,用rpm -qa | grep mysql 发现已经安装,
但是使用service mysqld start 显示mysqld命令不存在,后查看安装的mysql的程序发现,
mysql-server并没有安装,所以使用yum install mysql-server先进行安装,等待安装完
以后再次使用service mysqld start,一切顺利运行。
#service mysqld start
#cd /usr/bin
#mysqladmin -u root password ‘123456’ 设置默认root初始密码
#./mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.67 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> grant all privileges on . to root@’%’ identified by “root”; 给root所有权限
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges; 刷新权限设置
Query OK, 0 rows affected (0.00 sec)
mysql> grant select,update,insert,delete on . to root@192.168.0.100 identified by “root”;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
service mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.67 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set password=password(‘12345678’) where user=‘root’; 重新设置root密码
Query OK, 5 rows affected (0.00 sec)
Rows matched: 5 Changed: 5 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
vi /etc/sysconfig/iptables 防火墙增加3306端口的放通规则
/etc/sysconfig/iptables的内容,其中粗体一行为新加的。
# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT 新增防火墙放通3306端口
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT
# service iptables restart
iptables: Flushing firewall rules: [ OK ]
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Unloading modules: [ OK ]
iptables: Applying firewall rules: [ OK ]