MySQL doesn't start and the database is not being created either about slickstack

[damiafaw]

Thank you for the information - I kept seeing changes to the mysql install file and got excited and retried it a few times last few days.
Just running some tests against a copy of my live site at the moment, so was wanting to install from new and test - but the SQL was failing on install.

Keep up the good work, love how simple SlickStack is.

[damiafaw]

same for me also, mysql does not load/start and therefore database connection error.
Doesnt seem to have created the database either and I have run through it many many times now.

[damiafaw]

Tried again this morning, after it completed - there was no database created and no user.
Created database, created the user defined in the config file (that will be used in wp-config.php) and did the permissions;
mysql> CREATE DATABASE wordpress;
mysql> CREATE USER 'xxxxxxx'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON . TO 'xxxxxxxxx'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

Now it works - so something is broken in the SQL creation process

[jessuppi]

This is a known issue as we comb through updating the MySQL installation process to better support MySQL 8.0.x. We've begun splitting the ss-install into various sub-scripts for better organization, including ss-install-mysql:

https://github.com/littlebizzy/slickstack/blob/master/ss-install-mysql.txt

We are moving toward using the auth_socket for root user and initial setup process. A new user admin will be created for all database management (and PHP tools, etc) as needed.

The challenge is running setup using this method but then using TCP (127.0.0.1) for the WordPress database.

All feedback is welcome, there is also a brief discussion in our Facebook group too. Hopefully within the next few days this gets resolved, it was also complicated by some changes made in MySQL 8.0.17/18 as well...

[jessuppi]

Thanks again for all the feedback on this thread.

We did successfully simplify the MySQL installation although still cleaning up the code a bit. This was complicated due to breaking changes that MySQL introduced in minor version updates (definitely not semantic versioning!).

But it's been stable for more than a year now, which is good news.

• we also introduced a new script ss-install-mysql-database to separate that functionality
• Unix sockets will be default going forward for root MySQL user
• TCP will be default for non-root MySQL user (e.g. WordPress database user) to support remote databases, etc.

Also keep an eye on ss-functions as we optimize the bash aliases for mysql commands... all feedback is welcome, as we need to ensure these commands work on various Ubuntu LTS / MySQL versions.

Ref: https://github.com/littlebizzy/slickstack/blob/master/bash/ss-functions.txt