[SOLVED] Mysql problem

[tamtam]

I have mysql installed, or so it says on add/remove programs. But I am having trouble locating or running mysql.

There is no mysqld in /etc/init.d
cd: /var/lib/mysql: No such file or directory

I have uninstalled and reinstalled, anyone any idea what is happening.

[DBelton]

to start mysql on boot:

systemctl enable mysqld.service

You can start it without having to reboot:

systemctl start mysqld.service

[tamtam]

Hi DBelton, thanks for the prompt reply...

Sorry Guys,

Thought I had installed mysql, instead I was installing some package which installed some libraries and the database but not the actual server.

Uninstalled what I did install and installed the mysql-server package

Neither worked...

$ sudo systemctl enable mysqld.service
Failed to issue method call: No such file or directory

$ sudo systemctl start mysqld.service
Failed to issue method call: Unit mysqld.service failed to load: No such file or directory. 
See system logs and 'systemctl status mysqld.service' for details.

When I try to connect using root (presuming no password set I get

# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

OR with mysqladmin

mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Is it that there are extra steps to perform after installing mysql - through add/remove programs.
Can't find a relevant readme for mysql on the system.

Can MySql be installed by yum?

[Fenrin]

Originally Posted by tamtam

[...]

Can MySql be installed by yum?

yes, it can.

a guide:
Every Server Setup Imaginable: SMB, SSH, VPN, VNC, HTTPD (+ PHP), MySQL, More!

[Jamwa]

You have installed the client, but have you installed the server?

yum install mysql-server

service mysqld start