Recent content by aidin1840

my friend, maybe it is because of file permissions? files IN /var/lib/mysql should be 660. /var/lib/mysql should be 755. Any of its subdirectories should be 700. is it right? if it is right how can i change the permissions regarding this?now all off them are 755!!

could you introduce some of server management company? our licence does not include support.

i have another question: i have not any backup of my databases. if i back up /var/lib/mysql and rebuild and install new mysql is it possible to restore back databases from old /var/lib/mysql ? i mean replace old one with the newly built

mysql_backups exist but all the database backup is 2 Kb ? is it normal?!

[root@server custombuild]# mysql_upgrade The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server. To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not...

cd /usr/local/directadmin/custombuild ./build update ./build set mysql_inst mysql ./build set mysql 5.6 ./build mysql ./build set mysql 5.7 ./build mysql ./build set mysql 8.0 ./build mysql

[root@server ~]# sh -x /etc/init.d/mysqld start + . /etc/rc.d/init.d/functions ++ TEXTDOMAIN=initscripts ++ umask 022 ++ PATH=/sbin:/usr/sbin:/bin:/usr/bin ++ export PATH ++ '[' -z '' ']' ++ COLUMNS=80 ++ '[' -z '' ']' +++ /sbin/consoletype ++ CONSOLETYPE=pty ++ '[' -f /etc/sysconfig/i18n -a -z...

[root@server ~]# su - mysql -s /bin/bash -bash-4.1$ mysqld 2020-06-01T12:45:53.924439Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2020-06-01T12:45:53.924487Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)...

thanks but it is centos 6 and has not any journalctl ! [root@server ~]# journalctl -bash: journalctl: command not found

i have another question: i have not any backup of my databases. if i back up /var/lib/mysql and rebuild and install new mysql is it possible to restore back databases from old /var/lib/mysql ? i mean replace old one with the newly built

restart but still does not start😔

i have restart my server two times! nothing changed

no errors !

thanks for your reply! mysql log is empty !

Hello, i recently upgrade from 5.7 to 8 with custombuild 2.0. but after the completion Mysql did not start!! ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) i have done anything that described here...