欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

Linux + iptables + Mysql 初始配置_MySQL

程序员文章站 2022-05-24 14:31:19
...
iptables

配置网卡

方法一:把以下命令放在/etc/rc.d/init.d/rc.local文件中

[root@local root]# ifconfig eth0 down

[root@local root]# ifconfig eth0 up

[root@local root]# ifconfig eth0 192.168.0.2 netmask 255.255.255.0

[root@local root]# route add default gw 192.168.1.2


方法二:

vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0

ONBOOT=yes

BOOTPROTO=static

IPADDR=219.136.241.211

NETMASK=255.255.255.128

GATEWAY=192.168.1.1

vi /etc/resolv.conf

nameserver 8.8.8.8

/etc/init.d/network restart


配置防火墙

[root@local root]# vi /etc/sysconfig/iptables

[root@local root]# service iptables restart


yum安装mysql

[root@local root]# yum list | grep mysql

[root@local root]# yum list | grep mysql-server


/sbin/chkconfig –-add mysqld [在服务清单中添加mysql服务]

service mysqld start;(即/etc/init.d/mysqld start。也可设成开机自启动:/sbin/chkconfig mysqld on)


更改 root 密码: mysqladmin -u root password 'newpassword'


添加mysql用户: GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password';

grant all on *.* to "root"@"%" identified by "123456";

(update user set host = ’%’ where user = ’root’;)

重载权限: mysql> FLUSH PRIVILEGES;


删除test数据库: mysql -u root -p mysql> DROP DATABASE test;

删除匿名帐户: DELETE FROM mysql.user WHERE user = '';


关机

shutdown -h now


Windows

route change 0.0.0.0 mask 0.0.0.0 192.168.1.1