

Mysqld 0:off 1:off 2:on 3:on 4:on 5:on mysql ] # chmod +x /etc/rc.d/init.d/mysqld mysql ] # chkconfig -add mysqld mysql ] # service mysqld status To see services enabled on particular target use If you want to list systemd services use 'systemctl list-unit-files'. SysV configuration data might be overridden by native

Note: This output shows SysV services only and does not include native Set boot up mysql ] # chkconfig -level 35 mysqld on mysql ] # chkconfig -list mysqld Start-up mysql service mysql ] # /etc/init.d/mysqld start Set file permissions mysql ] # chown 777 /etc/my.cnf mysql ] # chmod a+x /etc/init.d/mysqld Please consider using -initialize instead Please consider switching to mysqld -initialize Installation and initialization mysql ] #bin/mysql_install_db -user=mysql -basedir=/usr/local/mysql/ -datadir=/usr/local/mysql/data/ 10:09:58 mysql_install_db is deprecated. Lower_case_table_names = 1 max_allowed_packet =16M # The default storage engine that will be used when creating a new table # Maximum connections allowed max_connections = 200 # The character set used by the server defaults to 8 Bit coded latin1 Character set # Set up mysql Database data storage directory datadir =/usr/local/mysql/data Port = 3306 # Set up mysql Installation directory basedir =/usr/local/mysql Stay etc Next, create a new profile my.cnf, And add the following configuration in the file # Set up mysql Client default character set Mv mysql-5.7.21-linux-glibc2.12-x86_64/ /usr/local/mysql/Ĭhange the groups and users that you belong to chown -R mysql mysql/Ĭreate a database data store directory data cd /usr/local/mysql & mkdir data Unzip the file to the specified folder tar -vxzf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz Uninstall completely MySQL Methods install mysqlĮstablish mysql User group groupadd mysqlĮstablish mysql Users and join mysql User group useradd -g mysql mysql If there are other versions MySQL, Please delete it completely first CentOS 8 install mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz uninstall mysql
