debian教程,debian下mysql安装与配置(简单步骤)

时间:2021-06-17 15:49 作者:IIS7 admin

    #apt-get install mysql-server
    导出:
    #mysqldump -uroot -p[password]dbname> db.sql
    导入:
    #mysql -uroot -p[password]
    mysql> create database dbname;
    mysql> use dbname;
    mysql> dbname< db.sql
    mysql> exit;
    配置:
    1.防火墙开放端口3306;
    2.添加远程访问权限:
    #mysql -uroot -p[password]
    mysql> grant all PRIVILEGES on *.* to root@'%' identified by 'password';
    mysql> flush privileges;
    mysql> exit;
    3.编辑/etc/mysql/my.cnf,注释bind-address,或将ip改为0.0.0.0
    #service mysqld restart
    原文链接:https://blog.csdn.net/icysky1989/article/details/49999417