MySQL (5.5.55) installation from Binaries.
by Bolshedvorskii from LinuxQuestions.org on (#6D4H5)
Hello, everyone. I have some problem with installing binary.
You can scroll on, if you dont wanna ask Expected questions:
1. Why you want to install too old version?
- My company testing a old website project and we have a one rule: If this is working - dont touch it.
2. Why you want to install this from Binaries?
- I have already tried to install MySQL via .deb packages, however, they broke down and I abandoned this idea
______________________________________________________________
Following the steps from official MySQL manual I stopped at "Initializing the Data directory".
Code:root@test-udprf:/usr/local/mysql# bin/mysqld --initialize --user=mysql
230720 12:01:48 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
230720 12:01:48 [Note] bin/mysqld (mysqld 5.5.55) starting as process 153083 ...
bin/mysqld: Table 'mysql.plugin' doesn't exist
230720 12:01:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
230720 12:01:48 InnoDB: The InnoDB memory heap is disabled
230720 12:01:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230720 12:01:48 InnoDB: Compressed tables use zlib 1.2.11
230720 12:01:48 InnoDB: Initializing buffer pool, size = 128.0M
230720 12:01:48 InnoDB: Completed initialization of buffer pool
230720 12:01:48 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.After that error I tried to initialize as root
Code:root@test-udprf:/usr/local/mysql# bin/mysqld --initialize --user=root
230720 12:02:03 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
230720 12:02:03 [Note] bin/mysqld (mysqld 5.5.55) starting as process 153095 ...
bin/mysqld: Table 'mysql.plugin' doesn't exist
230720 12:02:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
230720 12:02:03 InnoDB: The InnoDB memory heap is disabled
230720 12:02:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230720 12:02:03 InnoDB: Compressed tables use zlib 1.2.11
230720 12:02:03 InnoDB: Initializing buffer pool, size = 128.0M
230720 12:02:03 InnoDB: Completed initialization of buffer pool
230720 12:02:03 InnoDB: highest supported file format is Barracuda.
230720 12:02:04 InnoDB: Waiting for the background threads to start
230720 12:02:05 InnoDB: 5.5.55 started; log sequence number 1595675
230720 12:02:05 [ERROR] bin/mysqld: unknown option '--initialize'
230720 12:02:05 [ERROR] Aborting
230720 12:02:05 InnoDB: Starting shutdown...
230720 12:02:06 InnoDB: Shutdown completed; log sequence number 1595675
230720 12:02:06 [Note] bin/mysqld: Shutdown completemysql_upgrade is not working.
Code:root@test-udprf:/usr/local/mysql# bin/mysql_upgrade --user=root
Looking for 'mysql' as: bin/mysql
Looking for 'mysqlcheck' as: bin/mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failedApparently, this version does not support the --initialize option, so what I should do?
I couldn't find the installation guide for this version on the internet.
You can scroll on, if you dont wanna ask Expected questions:
1. Why you want to install too old version?
- My company testing a old website project and we have a one rule: If this is working - dont touch it.
2. Why you want to install this from Binaries?
- I have already tried to install MySQL via .deb packages, however, they broke down and I abandoned this idea
______________________________________________________________
Following the steps from official MySQL manual I stopped at "Initializing the Data directory".
Code:root@test-udprf:/usr/local/mysql# bin/mysqld --initialize --user=mysql
230720 12:01:48 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
230720 12:01:48 [Note] bin/mysqld (mysqld 5.5.55) starting as process 153083 ...
bin/mysqld: Table 'mysql.plugin' doesn't exist
230720 12:01:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
230720 12:01:48 InnoDB: The InnoDB memory heap is disabled
230720 12:01:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230720 12:01:48 InnoDB: Compressed tables use zlib 1.2.11
230720 12:01:48 InnoDB: Initializing buffer pool, size = 128.0M
230720 12:01:48 InnoDB: Completed initialization of buffer pool
230720 12:01:48 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.After that error I tried to initialize as root
Code:root@test-udprf:/usr/local/mysql# bin/mysqld --initialize --user=root
230720 12:02:03 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
230720 12:02:03 [Note] bin/mysqld (mysqld 5.5.55) starting as process 153095 ...
bin/mysqld: Table 'mysql.plugin' doesn't exist
230720 12:02:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
230720 12:02:03 InnoDB: The InnoDB memory heap is disabled
230720 12:02:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230720 12:02:03 InnoDB: Compressed tables use zlib 1.2.11
230720 12:02:03 InnoDB: Initializing buffer pool, size = 128.0M
230720 12:02:03 InnoDB: Completed initialization of buffer pool
230720 12:02:03 InnoDB: highest supported file format is Barracuda.
230720 12:02:04 InnoDB: Waiting for the background threads to start
230720 12:02:05 InnoDB: 5.5.55 started; log sequence number 1595675
230720 12:02:05 [ERROR] bin/mysqld: unknown option '--initialize'
230720 12:02:05 [ERROR] Aborting
230720 12:02:05 InnoDB: Starting shutdown...
230720 12:02:06 InnoDB: Shutdown completed; log sequence number 1595675
230720 12:02:06 [Note] bin/mysqld: Shutdown completemysql_upgrade is not working.
Code:root@test-udprf:/usr/local/mysql# bin/mysql_upgrade --user=root
Looking for 'mysql' as: bin/mysql
Looking for 'mysqlcheck' as: bin/mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failedApparently, this version does not support the --initialize option, so what I should do?
I couldn't find the installation guide for this version on the internet.