MariaDB 5.5 in CentOS

[Pzz]

I'v MariaDB 5.5 installed with CB 2.0 on my CentOS. I'd like to set my root password for MySQL/MariaDB.

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?

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...?

 

[smtalk]

From the error message you posted, it looks that mysqld_safe was still running on the server when you executed the command.

 

[zEitEr]

And probably missed something obvious...?

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

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.

 

[Pzz]

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

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.

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....