BG.VM--CentOS
1. CentOS 更改IP
局域网配置:
在虚拟机的[网络]连接方式中选择:仅主机(Host-Only)网络。
路径:vim /etc/sysconfig/network-scripts/ifcfg-eth0
BOOTPROTO = none
ONBOOT=yes
IPADDR=192.168.56.81
GATEWAY=192.168.56.1
配制完成之后:service network restart
连接外网配置:
在虚拟机的[网络]连接方式中增加:桥接网卡
cp /etc/sysconfig/network-scripts/ifcfg-eth0 /etc/sysconfig/network-scripts/ifcfg-eth1
vim /etc/sysconfig/network-scripts/ifcfg-eth1
DEVICE=eth1
HWADDR=08:00:27:...虚拟机网络设置部分的MAC地址
TYPE=Ethernet
ONBOOT=yes
USERCTL=no
PEERDNS=yes
NM_CONTROLLED=yes
BOOTPROTO=static
IPADDR=192.168.1.112
GATEWAY=192.168.1.1
DNS1=8.8.8.8
vim /etc/resolv.conf => nameserver 8.8.8.8
service network restart
MySQL
groupadd mysql
useradd mysql -s /sbin/nologin -g mysql -M
mv mysql-5.5.54-linux2.6-x86_64.tar.gz /home/ye/software/
cd /home/ye/software/
tar -xf mysql-5.5.54-linux2.6-x86_64.tar.gz #解压mysql软件
cd mysql-5.5.54-linux2.6-x86_64
mv /home/ye/software/mysql-5.5.54-linux2.6-x86_64/ /application/mysql-5.5.54/
cd /application/mysql-5.5.54/
ln -s /application/mysql-5.5.54/ /application/mysql #创建软连接
ls -l /application/mysql/support-files/*.cnf
cp /application/mysql/support-files/my-small.cnf /etc/my.cnf
mkdir -p /application/mysql/data
chown -R mysql.mysql /application/mysql/ #修改目录权限
/application/mysql/scripts/mysql_install_db --basedir=/application/mysql -- datadir=/application/mysql/data --user=mysql #初始化mysql
tree /application/mysql/data/ #查看
sed -i 's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe? /etc/init.d/mysqld ?#修改配置文件内默认的程序执行路径
cp support-files/mysql.server /etc/init.d/mysqld
cp /application/mysql/support-files/my-small.cnf /etc/my.cnf #拷贝mysql配置文件到指定的路径下。
vim /etc/my.cnf 后在mysql配置内添加basedir=/application/mysql #默认安装路径
chmod +x /etc/init.d/mysqld
ll /etc/init.d/mysqld
#修改配置文件内默认的程序执行路径
/etc/init.d/mysqld start
/application/mysql/bin/mysqld_safe --user=mysql& #另一种方式启动MYSQL
netstat -antlp 查看3306端口是否启动
chkconfig --add mysqld 添加服务
chkconfig mysqld on 设置mysql服务开机默认启动
chkconfig --list mysqld 查看服务状态
echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile #更改mysql命令的全局环境变量;另一种方法为把/application/mysql/bin/下面的命令拷贝到已经是全局系统命令的路径/usr/local/sbin下#
source /etc/profile
echo $PATH
mysql 测试登录,默认没有密码
mysqladmin -u root password 'ye123456' 设置root密码
设置完成root密码后需要对MYSQL进行安全配置
注:如遇到提示can't crate file '/tmp/*' 时需要对此目录添加权限chmod -R 1777 /tmp/
允许root使用密码从其他电脑连接
use mysql
update
user
set
host =
'%'
where
user
=
'root'
;
GRANT
ALL
PRIVILEGES
ON
*.*
TO
'root'
@
'%'
IDENTIFIED
BY
'123456'
WITH
GRANT
OPTION
;
FLUSH
PRIVILEGES
记得关闭防火墙:service iptables stop;