Page 1 of 1

Mysql connection on new install on a MAC

Posted: Wed Sep 29, 2010 3:14 pm
by LostOZ1
Hi, I have installed Mysql and PHP 5 and when I go to test php <info> I can see the Mysql section is there. I can run php scripts so all is fine there. Terminal n to mysql and can create db's.

I have added a test db with a user and password, set the permissions so it can see the dbs and has all privileges. But when I run the mysql_connect e.g.

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>???</title>
<meta http-equiv="content-type"
	cotent="text/html; charset=iso-8859-1" />
</head>
<body>
<?php
$username = "pee_wee";
$password = "let_me_in";
$hostname = "localhost";	
$dbh = mysql_connect($hostname, $username, $password) 
	or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
// you're going to do lots more here soon
mysql_close($dbh);
?>
</body>
</html>
and it only comes back with unable to connect, so questions are?

What have I done wrong?

How do I see the log files for php and mysql on a Mac?

Re: Mysql connection on new install on a MAC

Posted: Wed Sep 29, 2010 3:27 pm
by mikosiko
make a few changes in your code to looks like this :

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>???</title>
<meta http-equiv="content-type"
        cotent="text/html; charset=iso-8859-1" />
</head>
<body>
<?php
   // Define how to display/report errors
   ini_set("display_errors", "1");
   error_reporting(E_ALL);

   $username = "pee_wee";
   $password = "let_me_in";
   $hostname = "localhost";        
   $dbh = mysql_connect($hostname, $username, $password) 
        or die("Unable to connect to MySQL" . mysql_error());
   print "Connected to MySQL<br>";
   // you're going to do lots more here soon
   mysql_close($dbh);
?>
and check what errors are you getting

Re: Mysql connection on new install on a MAC

Posted: Thu Sep 30, 2010 11:46 am
by LostOZ1
many thanks for the help, appreciated.

I now get - Unable to connect to MySQLNo such file or directory

Re: Mysql connection on new install on a MAC

Posted: Sat Oct 02, 2010 11:56 am
by LostOZ1
Ok I have now tried to have the or die on the same lien, no help.

Tried to use root as the user, no help, replaced the localhost with the ip address and got:

Unable to connect to MySQLHost '192.168.13.37' is not allowed to connect to this MySQL server

I have been into mysql via terminal /usr/local/mysql/bin/mysql -u pee_wee -p
enter the password of let_me_in and it lets me in

Then use SHOW DATABASES; can see the first_test db in the list.
Then USE first_test; and connects me to that db.
Then DESCRIBE first_test; shows me the table and data typesSo now if I run STATUS; I get the following:


mysql> status;
--------------
/usr/local/mysql/bin/mysql Ver 14.14 Distrib 5.1.50, for apple-darwin10.3.0 (i386) using readline 5.1

Connection id: 23
Current database: first_test
Current user: pee_wee@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.50 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 3 days 22 hours 12 min 20 sec

Threads: 2 Questions: 37 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 9 Queries per second avg: 0.0
--------------

So know pee_wee@localhost is allowed, do I have to have the db I am connecting to in the php page connection for it to work?

At my wits end been on this now for a week trying different things, about to uninstall it all and restart, as I may have done some thing wrong in the install.

In the php info I have the following

Code: Select all

mysql

MySQL Support	enabled
Active Persistent Links	0
Active Links	0
Client API version	mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $

Directive	Local Value	Master Value
mysql.allow_local_infile	On	On
mysql.allow_persistent	On	On
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	3306	3306
mysql.default_socket	/var/mysql/mysql.sock	/var/mysql/mysql.sock
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

mysqli

MysqlI Support	enabled
Client API library version	mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $
Active Persistent Links	0
Inactive Persistent Links	0
Active Links	0

Directive	Local Value	Master Value
mysqli.allow_local_infile	On	On
mysqli.allow_persistent	On	On
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	/var/mysql/mysql.sock	/var/mysql/mysql.sock
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.max_persistent	Unlimited	Unlimited
mysqli.reconnect	Off	Off

mysqlnd

mysqlnd	enabled
Version	mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $
Compression	supported
Command buffer size	4096
Read buffer size	32768
Read timeout	31536000
Collecting statistics	Yes
Collecting memory statistics	No

Client statistics	
bytes_sent	0
bytes_received	0
packets_sent	0
packets_received	0
protocol_overhead_in	0
protocol_overhead_out	0
bytes_received_ok_packet	0
bytes_received_eof_packet	0
bytes_received_rset_header_packet	0
bytes_received_rset_field_meta_packet	0
bytes_received_rset_row_packet	0
bytes_received_prepare_response_packet	0
bytes_received_change_user_packet	0
packets_sent_command	0
packets_received_ok	0
packets_received_eof	0
packets_received_rset_header	0
packets_received_rset_field_meta	0
packets_received_rset_row	0
packets_received_prepare_response	0
packets_received_change_user	0
result_set_queries	0
non_result_set_queries	0
no_index_used	0
bad_index_used	0
slow_queries	0
buffered_sets	0
unbuffered_sets	0
ps_buffered_sets	0
ps_unbuffered_sets	0
flushed_normal_sets	0
flushed_ps_sets	0
ps_prepared_never_executed	0
ps_prepared_once_executed	0
rows_fetched_from_server_normal	0
rows_fetched_from_server_ps	0
rows_buffered_from_client_normal	0
rows_buffered_from_client_ps	0
rows_fetched_from_client_normal_buffered	0
rows_fetched_from_client_normal_unbuffered	0
rows_fetched_from_client_ps_buffered	0
rows_fetched_from_client_ps_unbuffered	0
rows_fetched_from_client_ps_cursor	0
rows_affected_normal	0
rows_affected_ps	0
rows_skipped_normal	0
rows_skipped_ps	0
copy_on_write_saved	0
copy_on_write_performed	0
command_buffer_too_small	0
connect_success	0
connect_failure	6
connection_reused	0
reconnect	0
pconnect_success	0
active_connections	0
active_persistent_connections	0
explicit_close	0
implicit_close	0
disconnect_close	0
in_middle_of_command_close	0
explicit_free_result	0
implicit_free_result	0
explicit_stmt_close	0
implicit_stmt_close	0
mem_emalloc_count	0
mem_emalloc_ammount	0
mem_ecalloc_count	0
mem_ecalloc_ammount	0
mem_erealloc_count	0
mem_erealloc_ammount	0
mem_efree_count	6
mem_malloc_count	0
mem_malloc_ammount	0
mem_calloc_count	0
mem_calloc_ammount	0
mem_realloc_count	0
mem_realloc_ammount	0
mem_free_count	0
proto_text_fetched_null	0
proto_text_fetched_bit	0
proto_text_fetched_tinyint	0
proto_text_fetched_short	0
proto_text_fetched_int24	0
proto_text_fetched_int	0
proto_text_fetched_bigint	0
proto_text_fetched_decimal	0
proto_text_fetched_float	0
proto_text_fetched_double	0
proto_text_fetched_date	0
proto_text_fetched_year	0
proto_text_fetched_time	0
proto_text_fetched_datetime	0
proto_text_fetched_timestamp	0
proto_text_fetched_string	0
proto_text_fetched_blob	0
proto_text_fetched_enum	0
proto_text_fetched_set	0
proto_text_fetched_geometry	0
proto_text_fetched_other	0
proto_binary_fetched_null	0
proto_binary_fetched_bit	0
proto_binary_fetched_tinyint	0
proto_binary_fetched_short	0
proto_binary_fetched_int24	0
proto_binary_fetched_int	0
proto_binary_fetched_bigint	0
proto_binary_fetched_decimal	0
proto_binary_fetched_float	0
proto_binary_fetched_double	0
proto_binary_fetched_date	0
proto_binary_fetched_year	0
proto_binary_fetched_time	0
proto_binary_fetched_datetime	0
proto_binary_fetched_timestamp	0
proto_binary_fetched_string	0
proto_binary_fetched_blob	0
proto_binary_fetched_enum	0
proto_binary_fetched_set	0
proto_binary_fetched_geometry	0
proto_binary_fetched_other	0
init_command_executed_count	0
init_command_failed_count	0
com_quit	0
com_init_db	0
com_query	0
com_field_list	0
com_create_db	0
com_drop_db	0
com_refresh	0
com_shutdown	0
com_statistics	0
com_process_info	0
com_connect	0
com_process_kill	0
com_debug	0
com_ping	0
com_time	0
com_delayed_insert	0
com_change_user	0
com_binlog_dump	0
com_table_dump	0
com_connect_out	0
com_register_slave	0
com_stmt_prepare	0
com_stmt_execute	0
com_stmt_send_long_data	0
com_stmt_close	0
com_stmt_reset	0
com_stmt_set_option	0
com_stmt_fetch	0
com_deamon	0

odbc

ODBC Support	enabled
Active Persistent Links	0
Active Links	0
ODBC library	iodbc
ODBC_INCLUDE	-I/usr/include
ODBC_LFLAGS	-L/usr/lib
ODBC_LIBS	-liodbc

Directive	Local Value	Master Value
odbc.allow_persistent	On	On
odbc.check_persistent	On	On
odbc.default_cursortype	Static cursor	Static cursor
odbc.default_db	no value	no value
odbc.default_pw	no value	no value
odbc.default_user	no value	no value
odbc.defaultbinmode	return as is	return as is
odbc.defaultlrl	return up to 4096 bytes	return up to 4096 bytes
odbc.max_links	Unlimited	Unlimited
odbc.max_persistent	Unlimited	Unlimited