Page 1 of 1
How to properly install MySQL 8 in fossapup 9.5? (solved)
Posted: Thu Mar 24, 2022 2:26 pm
by 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.
Re: How to properly install MySQL 8 in fossapup 9.5?
Posted: Thu Mar 24, 2022 3:22 pm
by rockedge
@mr_gs Hello and ![Welcome :welcome:](./images/smilies/welcome.gif)
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.
Re: How to properly install MySQL 8 in fossapup 9.5?
Posted: Sat Mar 26, 2022 2:40 pm
by mr_gs
Thanks buddy. I've successfully installed it. ![Thumbup :thumbup:](./images/smilies/thumbup.gif)
Re: How to properly install MySQL 8 in fossapup 9.5? (solved)
Posted: Sat Mar 26, 2022 4:03 pm
by rockedge
@mr_gs That's good news! Are you also using PHP 8 (or 7+) or straight database SQL?
Re: How to properly install MySQL 8 in fossapup 9.5? (solved)
Posted: Sun Mar 27, 2022 1:54 am
by 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 ![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Re: How to properly install MySQL 8 in fossapup 9.5? (solved)
Posted: Sun Mar 27, 2022 2:46 am
by rockedge
@mr_gs Excellent. ![Thumbup :thumbup:](./images/smilies/thumbup.gif)