# --------------------------------------------------------- # --- : CentOs # http://www.rackspace.com/knowledge_center/article/installing-mysql-server-on-centos # # --- : CentOs 7 yum install mariadb-server systemctl start mariadb systemctl enable mariadb # --- : CentOs 6 yum install mysql-server service mysqld start chkconfig mysqld on yum install mysql-server /sbin/service mysqld start # /usr/bin/mysql_secure_installation # -I INPUT -p tcp --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT -I OUTPUT -p tcp --sport 3306 -m state --state ESTABLISHED -j ACCEPT # /sbin/service mysqld start # chkconfig mysqld on # Set the root password /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root --password='new-password' -h hostname-of-your-server 'new-password' # # --------------------------------------------------------- # --- : # # --- : Denian # aptitude update && aptitude upgrade apt-get update && apt-get upgrade # apt-get install mysql-server mysql-common mysql-client # Set root password apt-get install php5-mysql apt-get install libdbd-mysql-perl # --------------------------------------------------------- # --- : # mysql_secure_installation # --- : MySQL server configuration vi /etc/mysql/my.cnf