Mysql 설정

Computer/Linux 2017.09.28 14:43

Remove all files related to MySQL


sudo apt-get purge mysql*

sudo apt-get autoremove

sudo apt-get autoclean


rm -rf /rm -rf /var/log/mysql

rm -rf /var/log/mysql.*

rm -rf /var/lib/mysql

rm -rf /etc/mysqlvar/log/mysql

rm -rf /var/log/mysql.*

rm -rf /var/lib/mysql

rm -rf /etc/mysql

        

        sudo apt-get remove dbconfig-mysql



Then upgrade my distribution


sudo apt-get dist-upgrade


Then install MySQL 


    sudo apt-get update

    sudo apt-get install mysql-server



To initialize the MySQL data directory, you would use mysql_install_db for versions before 5.7.6, and mysqld --initialize for 5.7.6 and later. However, if you installed MySQL from the Debian distribution, like in Step 1, the data directory was initialized automatically; you don't have to do anything. If you try running the command anyway, you'll see the following error:



mysqld --verbose --lower-case-table-names=1 --character-set-server=utf8 --collation-server=utf8_general_ci --transaction-isolation=READ-COMMITTED


PASSWORD 복잡성해제

/usr/lib64/mysql/plugin/ 경로에 있는 validate_password.so을 삭제 하거나 이름을 변경



sudo service mysql restart


firewall setting


sudo ufw allow 22

sudo ufw allow ssh

'Computer > Linux' 카테고리의 다른 글

Mysql 설정  (0) 2017.09.28
Posted by 삼백야드


티스토리 툴바