cant setup maria/mysqlDB on netbook
by however from LinuxQuestions.org on (#5GCN9)
Hello folks,
sometimes i forget the fun of reading all the insults, attacks, critics, comments mocking, etc... of users on other users
Anyway, I am banging my head on a wall here, because for the last 2days i have been trying to setup maria/mysql DB on a netbook after i upgraded to slackware current.
I read this post which, i am not sure has the same issue but, no solution is given.
The peculiarity is that I did manage to setup mariaDb on my laptop and desktop in the past few months (although, i remember it was a painstaking job) but nothing seems to work for this netbook.
So, what i have done:
1) of course, follow the tutorials on slackware docs;
- outcome:Code:bash-5.1# mysql_install_db
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2021-04-09 15:04:26 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2021-04-09 15:04:26 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2021-04-09 15:04:26 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-04-09 15:04:26 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-04-09 15:04:26 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-04-09 15:04:26 0 [ERROR] Aborting
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:
shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf
You can also try to start the mysqld daemon with:
shell> /usr/libexec/mysqld --skip-grant-tables --general-log &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables;
Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /var/lib/mysql that may be helpful.
The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss
Please check all of the above before submitting a bug report
at https://mariadb.org/jira
bash-5.1#a- yes, i did try the suggestions on that msg with no avail
b- i tried to check the log in /var/lib/mysql and there is no actual txt format log; 4 files all appear in database encrypted form i.e. aria_log.000001, aria_log_control, ib_logfiles101 and ibdata1
c- it was exactly the same error msg executing mysql_install_db --user=mysql
At this point i knew that it was pointless to try further but i did it anyway
2) /etc/rc.d/rc.mysqld start
Code:bash-5.1# /etc/rc.d/rc.mysqld start
bash-5.1# 210409 15:35:25 mysqld_safe Logging to '/var/lib/mysql/localhost.home.err'.
210409 15:35:26 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
/usr/bin/mysqld_safe_helper: Can't create/write to file '/var/lib/mysql/localhost.home.err' (Errcode: 13 "Permission denied")(not sure what "Permission Denied" meant; I was superuser and it did create 4 log files so, I dont understand how it was 'denied' to create another)
3) then tried to run mysql_secure_installation anyway
Code:bash-5.1# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
haven't set the root password yet, you should just press enter here.
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Enter current password for root (enter for none):(no matter whether I left it blank or inputted 'mambo-jumbo')
4) i thought, ok let's give it what it wants, a password
Code:bash-5.1# mysqladmin -u root password '*********'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
bash-5.1#And then i remembered that I had the same issue with the missing (damn) mysql.sock file that wouldn't create on the desktop and laptop too.
I remember that i tried several tutorials before finding the one that worked 2mnths ago but can't remember how or where i did it and i can't find it again.
Any suggestions will be welcomed.
sometimes i forget the fun of reading all the insults, attacks, critics, comments mocking, etc... of users on other users
Anyway, I am banging my head on a wall here, because for the last 2days i have been trying to setup maria/mysql DB on a netbook after i upgraded to slackware current.
I read this post which, i am not sure has the same issue but, no solution is given.
The peculiarity is that I did manage to setup mariaDb on my laptop and desktop in the past few months (although, i remember it was a painstaking job) but nothing seems to work for this netbook.
So, what i have done:
1) of course, follow the tutorials on slackware docs;
- outcome:Code:bash-5.1# mysql_install_db
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2021-04-09 15:04:26 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2021-04-09 15:04:26 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2021-04-09 15:04:26 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-04-09 15:04:26 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-04-09 15:04:26 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-04-09 15:04:26 0 [ERROR] Aborting
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:
shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf
You can also try to start the mysqld daemon with:
shell> /usr/libexec/mysqld --skip-grant-tables --general-log &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables;
Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /var/lib/mysql that may be helpful.
The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss
Please check all of the above before submitting a bug report
at https://mariadb.org/jira
bash-5.1#a- yes, i did try the suggestions on that msg with no avail
b- i tried to check the log in /var/lib/mysql and there is no actual txt format log; 4 files all appear in database encrypted form i.e. aria_log.000001, aria_log_control, ib_logfiles101 and ibdata1
c- it was exactly the same error msg executing mysql_install_db --user=mysql
At this point i knew that it was pointless to try further but i did it anyway
2) /etc/rc.d/rc.mysqld start
Code:bash-5.1# /etc/rc.d/rc.mysqld start
bash-5.1# 210409 15:35:25 mysqld_safe Logging to '/var/lib/mysql/localhost.home.err'.
210409 15:35:26 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
/usr/bin/mysqld_safe_helper: Can't create/write to file '/var/lib/mysql/localhost.home.err' (Errcode: 13 "Permission denied")(not sure what "Permission Denied" meant; I was superuser and it did create 4 log files so, I dont understand how it was 'denied' to create another)
3) then tried to run mysql_secure_installation anyway
Code:bash-5.1# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
haven't set the root password yet, you should just press enter here.
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Enter current password for root (enter for none):(no matter whether I left it blank or inputted 'mambo-jumbo')
4) i thought, ok let's give it what it wants, a password
Code:bash-5.1# mysqladmin -u root password '*********'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
bash-5.1#And then i remembered that I had the same issue with the missing (damn) mysql.sock file that wouldn't create on the desktop and laptop too.
I remember that i tried several tutorials before finding the one that worked 2mnths ago but can't remember how or where i did it and i can't find it again.
Any suggestions will be welcomed.