福建搜索引擎优化,网站优化潍坊,flask做的网站如何上传,wordpress只能建博客吗本人在虚拟机上又安装了一台linux机器#xff0c;作为MySQL数据库服务器用#xff0c;在安装时选择了系统自带的MySQL服务器端#xff0c;以下是启用步骤。首先开启mysqld服务#service mysqld start进入/usr/bin目录#cd /usr/bin设定mysql数据库root用户的密码#mysqladmin -…本人在虚拟机上又安装了一台linux机器作为MySQL数据库服务器用在安装时选择了系统自带的MySQL服务器端以下是启用步骤。首先开启mysqld服务#service mysqld start进入/usr/bin目录#cd /usr/bin设定mysql数据库root用户的密码#mysqladmin -u root password 123456进入mysql数据库管理控制台#./mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.0.67 Source distributionType help; or \h for help. Type \c to clear the buffer.mysql grant all privileges on *.* to root% identified by 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 root192.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 quitBye上面的步骤是进行授权然后重启mysqld服务# service mysqld restartStopping MySQL: [ OK ]Starting MySQL: [ OK ]再次进入mysql管理控制台# mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.0.67 Source distributionType help; or \h for help. Type \c to clear the buffer.mysql use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql update user set passwordpassword(12345678) where userroot;Query OK, 5 rows affected (0.00 sec)Rows matched: 5 Changed: 5 Warnings: 0mysql flush privileges;Query OK, 0 rows affected (0.00 sec)mysql quitBye以上步骤是修改root用户的密码之后开启防火墙的3306端口# vi /etc/sysconfig/iptables以下是/etc/sysconfig/iptables的内容其中蓝色一行是新加的。这一行可以由上一行复制得到方法是在22哪行按下yy然后按p然后点insert键进入编辑模式修改22为3306然后点esc输入wq保存退出。# 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-A INPUT -j REJECT --reject-with icmp-host-prohibited-A FORWARD -j REJECT --reject-with icmp-host-prohibitedCOMMIT防火墙重启# service iptables restartiptables: Flushing firewall rules: [ OK ]iptables: Setting chains to policy ACCEPT: filter [ OK ]iptables: Unloading modules: [ OK ]iptables: Applying firewall rules: [ OK ]之后就可以在192.168.0.100上用mysqlfront连接数据库了。本文转自张昺华-sky博客园博客原文链接http://www.cnblogs.com/xiandedanteng/p/5799417.html如需转载请自行联系原作者
