Where are the database files for mysql in Centos 5?

Anauj0101 · 02-20-2008, 11:53 PM

Where are the database files for mysql in Centos 5?

This would be mysql ver 5
The problem i am having is that i cant connect to mysql from apache all of my php script works and i can make, use, edit tables from the command line but the connect statement does nothing, not even an error message.
$connection = mysql_connect("localhost","user","password");
if (!$connection) {
echo "COULD NOT CONNECT!!";
}
echo "connect successful";

Angel2953 · 02-21-2008, 03:13 AM

if you wana find mysql db files then run this:

Code:

# find / -name "*.MYI" -exec ls -al {} \;

this will find any file that has extension MYI (one of mysql table files)

But you might have display_errors set to off in your php.ini then it should be like this:

Code:

<?php
init_set('display_errors', 1 );
error_reporting( E_ALL );

// rest of your script
?>

Anauj0101 · 02-21-2008, 10:53 AM

Well thanks i found the db files, but when i enter the code it does nothing after it, not even a simple echo statement. Im stumped, the php.ini file seems to be set up to work with mysql. It should work right?

Angel2953 · 02-21-2008, 11:11 AM

just for sure run this:

Code:

$ php --ri mysql

you should get something like this:

Code:

dawid@rei:~$ php --ri mysql

mysql

MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 5.0.51
MYSQL_MODULE_TYPE => external
MYSQL_SOCKET => /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE => -I/usr/include/mysql
MYSQL_LIBS => -L/usr/lib -lmysqlclient

Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.max_persistent => Unlimited => Unlimited
mysql.max_links => Unlimited => Unlimited
mysql.default_host => no value => no value
mysql.default_user => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => no value => no value
mysql.connect_timeout => 60 => 60
mysql.trace_mode => Off => Off
dawid@rei:~$

Does simple echo statement work or doesn't display anything (sth like: <?php echo "test\n"; ?>) and does

Code:

<?php phpinfo(); ?>

displays anything ? If no then maybe you have some buffering/caching options enabled that prevents displaying results...

Anauj0101 · 02-21-2008, 10:36 PM

When i type the line, php --ri mysql
I get
Could not open input file: mysql

And yes phpinfo does work

Anauj0101 · 02-23-2008, 05:39 PM

Thanks for all the help, i fixed it by accident. Apparently i didnt initialize something because a restart fixed it.......I feel somewhat stupid now.