Tiny Core Linux

Tiny Core Base => TCB Q&A Forum => Topic started by: Yarpi on January 01, 2024, 02:43:15 PM

Title: How to run mysqld on CorePlus?
Post by: Yarpi on January 01, 2024, 02:43:15 PM

Hello,

it's almost one week I'm trying to figure out how to run mysqld on my CorePlus installation (latest version), it cannot start as root. I'm using the binary /usr/local/mysql/bin/mysqld I've installed mariadb-10.4.tcz. Errors printed out:

Code: [Select]

[Warning] Could not increase number of max_open_files to more than 1024 (request: 4186)
[Warning] Changed limits: max_open_files: 1024   max_connections: 151 (was 151) table_cache: 421 (was 2000)
[Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
[Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
[Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
[Error] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
[Error] Server socket created on IP: '::'
[Error] Can't start server: Bind on unix socket: Permission denied
[Error] Do you already have another mysqld server running on socket: /var/run/mysql.sock?

I have found a guide online but it is not useful, because it's not updated. Link: https://www.parkytowers.me.uk/thin/Linux/TinycoreWP.shtml (https://www.parkytowers.me.uk/thin/Linux/TinycoreWP.shtml) Even a live tinycore give almost the same errors with any version of mariadb.

Thank you in advance.
I hope I'm not spamming, it's my second post ;D  :-\

Title: Re: How to run mysqld on CorePlus?
Post by: andyj on January 02, 2024, 12:46:47 AM

Try this to create a database:

Code: [Select]

/usr/local/mysql/scripts/mysql_install_db --no-defaults --basedir=/usr/local/mysql --datadir=/path/to/maria-DB/data
Then do this to start the database:

Code: [Select]

sudo chmod 1777 /var/run
sudo /usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql --datadir=/path/to/maria-DB/data --syslog --user=tc &


Title: [Solved] Re: How to run mysqld on CorePlus?
Post by: Yarpi on January 02, 2024, 04:03:57 PM

Thank you so much it works!