• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue After installing mysql 5.6-e17 my plesk and etire mysql not working

junaidskp

New Pleskian
After installing new version mysql 5.6.-e17 on my centos cant' start mysql and cant open my plesk login page also cant' open my websites pages only working ssh i dont know what can i do for repair this please help me !!!!!!!!!!!
This is my mysql log.

160802 23:57:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-08-02 23:57:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-02 23:57:59 0 [Note] /usr/sbin/mysqld (mysqld 5.6.32) starting as process 13856 ...
2016-08-02 23:57:59 13856 [Note] Plugin 'FEDERATED' is disabled.
2016-08-02 23:57:59 13856 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-02 23:57:59 13856 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-02 23:57:59 13856 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-02 23:57:59 13856 [Note] InnoDB: Memory barrier is not used
2016-08-02 23:57:59 13856 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-02 23:57:59 13856 [Note] InnoDB: Using Linux native AIO
2016-08-02 23:57:59 13856 [Note] InnoDB: Using CPU crc32 instructions
2016-08-02 23:57:59 13856 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-08-02 23:57:59 13856 [Note] InnoDB: Completed initialization of buffer pool
2016-08-02 23:57:59 13856 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-02 23:58:00 13856 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=775811126
2016-08-02 23:58:00 13856 [Warning] InnoDB: Starting to delete and rewrite log files.
2016-08-02 23:58:00 13856 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2016-08-02 23:58:01 13856 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2016-08-02 23:58:02 13856 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-08-02 23:58:02 13856 [Warning] InnoDB: New log files created, LSN=775811126
2016-08-02 23:58:02 13856 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-02 23:58:02 13856 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-08-02 23:58:02 13856 [Note] InnoDB: Tablespace and datafile system tables created.
2016-08-02 23:58:02 13856 [Note] InnoDB: Waiting for purge to start
2016-08-02 23:58:02 13856 [Note] InnoDB: 5.6.32 started; log sequence number 775811126
2016-08-02 23:58:02 13856 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2f186d78-58fc-11e6-971d-d050997ce85a.
2016-08-02 23:58:02 13856 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-02 23:58:02 13856 [Note] IPv6 is available.
2016-08-02 23:58:02 13856 [Note] - '::' resolves to '::';
2016-08-02 23:58:02 13856 [Note] Server socket created on IP: '::'.
2016-08-02 23:58:02 13856 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2016-08-02 23:58:02 13856 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure

And this when i enter :
[root@admin51830019 log]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
[root@admin51830019 log]# mysqld
160807 12:30:57 [Note] mysqld (mysqld 10.0.26-MariaDB) starting as process 3969 ...
160807 12:30:57 [ERROR] Fatal error: Please consult the Knowledge Base to find out how to run mysqld as root!

160807 12:30:57 [ERROR] Aborting

160807 12:30:57 [Note] mysqld: Shutdown complete

And when trying to start mysqld:

[root@admin51830019 /]# service mysqld start
mysqld: unrecognized service
[root@admin51830019 /]# service mysql start
mysql: unrecognized service
 
(mysqld 10.0.26-MariaDB)
service mariadb restart ????

Just you need to fix this:

160807 12:30:57 [Note] mysqld (mysqld 10.0.26-MariaDB) starting as process 3969 ...
160807 12:30:57 [ERROR] Fatal error: Please consult the Knowledge Base to find out how to run mysqld as root!
 
Looks like it hasn't finished installing/upgrading.
Have you tried to run...
Code:
# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`


Hope that helps
Kind regards

Lloyd
 
when i install new plesk give me the error:

**** Package pp12.5.30-bootstrapper scriptlet completed successfully.

STOP pp12.5.30-bootstrapper-12.5.30-cos6.build1205160608.10 installing AT Sat Jul 2 19:54:16 CEST 2016
START Bootstrapper 12.5.30 prep-install for BASE AT Sat Jul 2 19:54:17 CEST 2016

**** Product prep-install started.

===> Checking for previous installation ... found.
Create user 'psaadm' and group 'psaadm'
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Create group swkey-data
Checking for the group 'swkey-data'...
Group 'swkey-data' already exists
"plesk_12.5.30_installation.log" 4508L, 268076C
please help me what to do?
 
Well the problem wasn't Plesk, it was MySQL; an OS package.

Did you get MySQL started?

# service mariadb status

If not and you are still getting the error reported in first post, run the command I gave earlier and see if MySQL starts again.
I hope it helps

Kind regards

Lloyd
 
Last edited:
Here is result.

[root@admin51830019 ~]# service mariadb status
mariadb: unrecognized service
[root@admin51830019 ~]#
 
Here is result.

[root@admin51830019 ~]# service mariadb status
mariadb: unrecognized service
[root@admin51830019 ~]#

Sorry, I meant...
Code:
# service mysqld status

If still down, run...
Code:
# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

To finish the MySQL upgrade.
Kind regards

Lloyd
 
Here its come result.

[root@admin51830019 /]# service mysqld status
crond (pid 17084) is running...
[root@admin51830019 /]# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`
cat: /etc/psa/.psa.shadow: No such file or directory
Enter password:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
FATAL ERROR: Upgrade failed
[root@admin51830019 /]#
 
Back
Top