LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 09-05-2021, 11:02 AM   #1
tasoss
LQ Newbie
 
Registered: Aug 2021
Posts: 10

Rep: Reputation: Disabled
Question mariadb not starting(current64)


Hello.
As the title says i'm having problems starting mariadb on current64.
So,I install from current64 and select rc.mysqld (setup->services to start).

Code:
starla.desolation.net.err                                                                                                      
210904 22:53:55 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
2021-09-04 22:53:56 0 [Note] /usr/libexec/mariadbd (mysqld 10.5.12-MariaDB) starting as process 1089 ...
2021-09-04 22:53:56 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2021-09-04 22:53:56 0 [Note] InnoDB: Uses event mutexes
2021-09-04 22:53:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-04 22:53:56 0 [Note] InnoDB: Number of pools: 1
2021-09-04 22:53:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-09-04 22:53:56 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-09-04 22:53:56 0 [Note] InnoDB: Using Linux native AIO
2021-09-04 22:53:56 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2021-09-04 22:53:56 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-04 22:53:56 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-04 22:53:56 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
2021-09-04 22:53:56 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes
2021-09-04 22:53:56 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-09-04 22:53:56 0 [Note] InnoDB: New log file created, LSN=10317
2021-09-04 22:53:56 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2021-09-04 22:53:56 0 [Note] InnoDB: Doublewrite buffer created
2021-09-04 22:53:56 0 [Note] InnoDB: 128 rollback segments are active.
2021-09-04 22:53:56 0 [Note] InnoDB: Creating foreign key constraint system tables.
2021-09-04 22:53:56 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2021-09-04 22:53:56 0 [Note] InnoDB: Creating sys_virtual system tables.
2021-09-04 22:53:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-04 22:53:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-04 22:53:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-09-04 22:53:56 0 [Note] InnoDB: 10.5.12 started; log sequence number 0; transaction id 7
2021-09-04 22:53:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-04 22:53:56 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
2021-09-04 22:53:56 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2021-09-04 22:53:56 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
2021-09-04 22:53:56 0 [ERROR] Aborting
I have tried to run the various scripts and start with mysqld_safe but i always get errors about missing tables.

Thanks!
 
Old 09-05-2021, 11:09 AM   #2
ponce
LQ Guru
 
Registered: Aug 2004
Location: Pisa, Italy
Distribution: Slackware
Posts: 7,098

Rep: Reputation: 4175Reputation: 4175Reputation: 4175Reputation: 4175Reputation: 4175Reputation: 4175Reputation: 4175Reputation: 4175Reputation: 4175Reputation: 4175Reputation: 4175
you probably haven't created the needed tables before starting mariadb: in /etc/rc.d/rc.mysqld there's this bit
Code:
# Before you can run MariaDB, you must have a database.  To install an initial
# database, do this as root:
#
#   mysql_install_db --user=mysql
#
# Note that the mysql user must exist in /etc/passwd, and the created files
# will be owned by this dedicated user.  This is important, or else mysql
# (which runs as user "mysql") will not be able to write to the database
# later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').
#
# To increase system security, consider using "mysql_secure_installation"
# as well.  For more information on this tool, please read:
#   man mysql_secure_installation
so now you have to issue these two commands
Code:
chown -R mysql.mysql /var/lib/mysql
mysql_install_db --user=mysql
and then start the server with
Code:
chmod +x /etc/rc.d/rc.mysqld
/etc/rc.d/rc.mysqld start
 
Old 09-05-2021, 11:13 AM   #3
tasoss
LQ Newbie
 
Registered: Aug 2021
Posts: 10

Original Poster
Rep: Reputation: Disabled
Hello and thanks for replying.
My mistake that i didn't open /etc/rc.d/rc.mysqld.
I thought that by selecting it via the setup , it would run all things necessary.
Thanks!
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mariadb not starting at all kajlaajay Linux - Server 16 01-21-2020 03:44 AM
LXer: KDE Participating in Google Summer of Code 2019, MariaDB Releasing New Open-Source MariaDB Enterprise Server, CentOS Celebrates 15th B LXer Syndicated Linux News 0 02-28-2019 06:50 AM
Current64 - Firefox 63.0.3: LQ not obeying the window width? burdi01 Slackware 3 12-02-2018 03:37 AM
Current64: mke2fs (aka mkfs.ext4): 64-bit filesystem support is not enabled. burdi01 Slackware 3 04-14-2018 02:54 AM
[SOLVED] Starting File System .. Starting File System .. Starting File System .. Starting File rmknox Linux - Newbie 3 08-15-2010 11:30 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 05:56 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration