Which DIR is the MySQL base directory after yum installed mysql

Question

Seems that I cannot locate mysql DIR only bunch of binary files under /usr/bin

I used yum to install

mysql
mysql-server
mysql-devel

and tried to install mysql and I used /init.d/mysqld to have started it.

But when I want to compile PHP , the option --with-mysql need the base DIR of mysql ...where should I use? /usr/bin?

RolandoMySQLDBA · Accepted Answer · 2013-12-13 21:17:47Z

4

You should run this command

mysqladmin -uroot variables | grep datadir | sed 's/|/ /g' | awk '{print $2}'

to find the default data directory.

If you cannot login to mysql just yet, you can still run this

which mysqld
which mysqld_safe

to locate the binaries.

Give it a Try !!!

answered Dec 13, 2013 at 21:17

RolandoMySQLDBA

3,1551 gold badge21 silver badges25 bronze badges

Add a comment |

studiohack · Accepted Answer · 2011-05-21 00:25:21Z

1

Have you tried: /usr/local/mysql/bin?

studiohack

13.5k19 gold badges88 silver badges118 bronze badges

answered May 20, 2011 at 23:55

Justin Pearce

3,01019 silver badges21 bronze badges

no mysql directory under /usr/local
– Hao
May 23, 2011 at 3:45
Did you look in /usr/bin for the binaries?
– Justin Pearce
May 23, 2011 at 18:51
Yes, that's the only place that I thought MySQL yum install had been installed files to..
– Hao
May 24, 2011 at 6:41
Depending upon the distro and/or package it usually puts things in either /usr/bin or /usr/local/bin. Glad you got it sorted!
– Justin Pearce
May 24, 2011 at 18:43

Add a comment |

2 Answers 2