Installer Script/Mysql
I tried the installer script on a couple different versions of Linux. CentOS 6/7 and Debian 8.8. On all three they error on the same place. Logging into mysql and creating the database. At first I thought maybe it was the cantankerous version of CentOS. Then I read Debian was preferred. I ran the script and answered the questions. It acts as tho it doesn't save the value when asked. I am going to take another pass at it and post the error. It is likely I missed something but after 3 passes I don't know what it is. Any suggestions would be appreciated.
- ceq |
Error Message
Here is the error.
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'localhost' I can see the script install mysql/mariadb. Not sure what is wrong. - ceq |
More specifically:
170614 15:36:13 [Note] /usr/sbin/mysqld (mysqld 10.0.30-MariaDB-0+deb8u2) starting as process 29551 ... Setting up libhtml-template-perl (2.95-1) ... Setting up mariadb-server (10.0.30-0+deb8u2) ... Processing triggers for libc-bin (2.19-18+deb8u9) ... Processing triggers for systemd (215-17+deb8u7) ... ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'localhost' ---- ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'localhost' |
Quote:
|
Username/passwords
Are you referring to these fields? If so, I did fill in each accordingly.
Enter new UNIX password: Retype new UNIX password: Enter MySQL root (Database) password: Enter Database Name (single word, no special characters, lower case): Enter (Database) MySQL EQEmu Server username: Enter (Database) MySQL EQEmu Server password: |
As long as you did so as instructed, the installer shouldn't have an issue. We've ran through it many times. Make sure you run it as root
|
As Root
I have no doubt it works correctly. I am just missing something. I installed debian from scratch and updated. Installed GCC-4.9 and ran this:
root@debian:~# wget --no-check-certificate https://raw.githubusercontent.com/EQ...ler/install.sh -O install.sh && chmod 755 install.sh && ./install.sh --2017-06-14 15:28:58-- https://raw.githubusercontent.com/EQ...ler/install.sh That is all. - ceq |
Thanks
Also, thanks for your reply/assistance.
- ceq |
Mysql was not installed prior to running the script. The script did install and start the service. I can log in with the credentials I used during the script set up. Hence my confusion.
- ceq |
Well if you ran the script a few times of course you're going to see errors because its doing things it already did once.
|
Errors
Thanks for the reply. I understand the process which is why I run it from a fresh build. The error I get is on the first run. The database is never created as you can see by the error.
- ceq |
Just ran a fresh Debian install.
It all looks fine. Server started right up https://dl.dropboxusercontent.com/u/...mu_install.txt |
Install
I will give it another go on a fresh install and post the results.
Thanks. - ceq |
It may be helpful to share the bind address listed in your mysql config (my.cnf).
|
Resolved
This is a good one. Stop me if you heard it.
I enabled IMCP on our firewall and it worked like a charm. - ceq |
All times are GMT -4. The time now is 03:15 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.