MariaDB 5.5 in CentOS

Pzz

Pzz

Verified User
Joined
May 20, 2013
Messages
138
Location
The Hague area, The Netherlands
I'v MariaDB 5.5 installed with CB 2.0 on my CentOS. I'd like to set my root password for MySQL/MariaDB.

Code: 
21:35:09 root@server /$ mysqld_safe --skip-grant-tables
141001 21:35:25 mysqld_safe Logging to '/var/lib/mysql/<myservername>.err'.
141001 21:35:25 mysqld_safe A mysqld process already exists

Has this something to do with the CentOS firewalld I'm using?

Code: 
21:43:55 root@server /$ firewall-cmd --list-all
public (default, active)
  interfaces: eth0
  sources:
  services: dhcpv6-client dns http https ssh
  ports: 110/tcp 443/tcp 2222/tcp 25/tcp 587/tcp 10000/tcp 143/tcp 3306/tcp 53/tcp 995/tcp 53/udp 993/tcp
  masquerade: no
  forward-ports:
  icmp-blocks:
  rich rules:

I stopped services, killed processes... And probably missed something obvious...?
 
From the error message you posted, it looks that mysqld_safe was still running on the server when you executed the command.
 
Pzz said:
And probably missed something obvious...?
Click to expand...


MySQL root's password on Directadmin powered server can be discovered with the following command:

Code: 
grep ^mysql= /usr/local/directadmin/scripts/setup.txt | cut -d\= -f2

There in /usr/local/directadmin/scripts/setup.txt you can see other default passwords which are used on your server.
 
zEitEr said:
MySQL root's password on Directadmin powered server can be discovered with the following command:

Code: 
grep ^mysql= /usr/local/directadmin/scripts/setup.txt | cut -d\= -f2

There in /usr/local/directadmin/scripts/setup.txt you can see other default passwords which are used on your server.
Click to expand...

YES I found it! I thought there was no password set yet (I didn't) on default install, like all the MySQL-websites I searched say.

Thanx Alex for the info on the setup.txt also. I didn't knew that either.

There's still al lot to be learned....:eek:
 
You must log in or register to reply here.
Back
Top