'mqsql'에 해당되는 글 1건

  1. 2017.09.28 Mysql 설정

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


/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 삼백야드

댓글을 달아 주세요