MySQL / MariaDB for make PhantasyStar Online Blue Burst Local Server with Tethealla

Hi there, i had download and compile the follow source code :

git clone https://gitlab.com/theodis3/tethealla
cd tethealla
make
cd bin

Well now you need the files :
tethealla.ini
ship.ini
welcome.txt

and obviously all files need it by server (if you search on internet you can download ephinea Server&Client for example, you just need edit some ini files and change "" to "/" )


Well the thing is i need a working MySQL server, i had copy my Windows Servers File to this.

But after hours fixing MySQL errors, i never can make it work with a new user without password called "mysqluser"

https://gitlab.com/theodis3/tethealla/-/issues/3

Copy of i had post on that link :

Hi there, i had download and compile the binaries executables without problems, but from where i can generate the file " tethealla.ini "

Because the mayority of binaries executables show me the follow message :
"The configuration file tethealla.ini appears to be missing."

1 - Well from where i can get the files need to make a server ?
like tethealla.ini, ship.ini, patch.ini & welcome.txt

2 - if i want to make Spanish Translation for my server where must i use to edit text and where in path must locate the files ?

3 - Some how to include binaries for internal MySQL server just for use with this server ?

Because i am trying but i just got

> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2 "No such file or directory")

i try the follow

```
su
```

Password :

```
mkdir -p "/var/run/mysql"
touch "/var/run/mysql/mysql.sock"
/etc/rc.d/rc.mysqld stop
killall -9 mysqld_safe mysqld
chmod 755 /etc/rc.d/rc.mysqld
mysqld_safe --skip-grant-tables &
```

```
mysql -u root
use mysql;
select * from user;
set password = password('mypassword');
update user set password=PASSWORD("mypassword") where User='root';
update user set authentication_string=password('mypassword') where user='root';
UPDATE mysql.user SET Password=PASSWORD('mypassword') WHERE User='root';
flush privileges;
quit

mysql -u root -p mypassword
select user from mysql.user;
CREATE USER 'mysqluser'@'localhost' IDENTIFIED BY '123';
SHOW GRANTS FOR mysqluser@localhost;
quit
```

```
/etc/rc.d/rc.mysqld stop
killall -9 mysqld
```

You should editor the "my.cnf" file

```
editor /etc/my.cnf
```

Add at the end of file if does not exist :

```
[mysqld]
bind-address = 0.0.0.0
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
```

Save and exit

```
mysql_install_db --user=mysql
/etc/rc.d/rc.mysqld start
/usr/bin/mysql_secure_installation
```

Well i surrender i does not understand anything with the MySQL / MariaDB i just got

./make_key
Can't connect to the mysql server (localhost) on port 3306 !
mysql_error = Access denied for user 'mysqluser'@'localhost' (using password: YES)

i had create the mysqluser but i felt is overcomplicating too much just for make a local server inside an specific folder ¬¬.

Try to follow the instructions at https://docs.slackware.com/howtos:da...b_on_slackware to get mariadb running.
If you need network connectivity on port 3306, you need to edit /etc/rc.d/rc.mysqld and comment the line:

# To allow outside connections to the database comment out the next line. # If you don't need incoming network connections, then leave the line # uncommented to improve system security. SKIP="--skip-networking"

The, restart /etc/rc.d/rc.mysqld

Originally Posted by ctrlaltca Try to follow the instructions at https://docs.slackware.com/howtos:da...b_on_slackware to get mariadb running. If you need network connectivity on port 3306, you need to edit /etc/rc.d/rc.mysqld and comment the line: The, restart /etc/rc.d/rc.mysqld

I had follow that but is just reach the error i post the user root on @localhost