• The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

J

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 ~]#
 
junaidskp said:
Here is result.

[root@admin51830019 ~]# service mariadb status
mariadb: unrecognized service
[root@admin51830019 ~]#
Click to expand...

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 /]#
 
You must log in or register to reply here.

Similar threads

A
Resolved 500 Plesk\Exception\Database
Replies
1
Views
573
ayadai
A
M
Question Upgrade MariaDB 10.3 to 10.11 via Plesk 18.0.61 on Debian 10
Replies
1
Views
603
Kaspar@Plesk
Kaspar@Plesk
B
Resolved Can't start mariadb, nor the mysql service.
Replies
12
Views
7K
bitrogers
B
J
Resolved Can't login at Plesk admin panel (Plesk Onyx 17.0.17)
Replies
6
Views
10K
JVG
J
Endre
Issue Server Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
15
Views
8K
MihaiNecreala
M
Back
Top