How to properly install MySQL 8 in fossapup 9.5? (solved)

[mr_gs]

I'm a computer student. As part of our school curriculum for the year 2022, we are learning MySQL.
My puppy linux: fossapup 9.5 64 bit
I've installed MySQL 8 from puppy package manager. But the problem is I can't start mysqld server.
I've googled this many times but I couldn't solve the issue.

[rockedge]

@mr_gs Hello and

It can be a little tricky installing MySQL from the Puppy Package Manager.

Have you successfully initialized mysql after installation?
If so in terminal try:

Code: Select all

mysqld --initialize --user=mysql
mysqld &

what is the response?
here is a script I use to install mariaDB, look at it and see if it can help you. Otherwise I can walk you through an install to get you going.

Install mariaDB on Fossapup64

Code: Select all

#!/bin/sh

# # create the user for the mysql server
adduser mysql -D

#update repos
pkg repo-update

# install the mysql server and intialize it
pkg add mariadb mariadb-server

# create run time directories and set the correct permissions and ownership
[ ! -d  /var/run/mysqld ]  && mkdir /var/run/mysqld
[ ! -d  /var/run/mysqld ]  && mkdir /var/log/mysql
chown -R mysql /var/run/mysqld
chown -R mysql /var/log/mysql
mysql_install_db
sleep 2
mysqld  &
sleep 2
 
 echo "Make sure that NOBODY can access the server without a password"
 
# Make sure that NOBODY can access the server without a password
mysql -e "UPDATE mysql.user SET Password = PASSWORD('admin') WHERE User = 'root'"

# Kill the anonymous users
mysql -e "DROP USER ''@'localhost'"

# Because our hostname varies we'll use some Bash magic here.
mysql -e "DROP USER ''@'$(hostname)'"

# Make our changes take effect
mysql -e "FLUSH PRIVILEGES"

echo "Finished stage 1. mariadb is installed"

Have you looked into using XAMPP ??? https://www.apachefriends.org/download.html
this is an easy way to get started as well.

Let me know how you make out, I can always set up a fresh Fossapup64 and walk through a setup of a mysql 8 server.

[mr_gs]

Thanks buddy. I've successfully installed it.

[rockedge]

@mr_gs That's good news! Are you also using PHP 8 (or 7+) or straight database SQL?

[mr_gs]

This is year we are going to learn how to use SQL with python. I've also connected sql with python using python package mysql.connector

[rockedge]

@mr_gs Excellent.