MYSQL_GET_HOST_INFO(3) 1 MYSQL_GET_HOST_INFO(3)mysql_get_host_info - Get MySQL host infoSYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_get_host_info(3)
o PDO::getAttribute
string mysql_get_host_info ([resource $link_identifier = NULL])
DESCRIPTION
Describes the type of connection in use for the connection, including the server host name.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns a string describing the type of MySQL connection in use for the connection or FALSE on failure.
Example #1
mysql_get_host_info(3) example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL host info: %s
", mysql_get_host_info());
?>
The above example will output something similar to:
MySQL host info: Localhost via UNIX socket
mysql_get_client_info(3), mysql_get_proto_info(3), mysql_get_server_info(3).
PHP Documentation Group MYSQL_GET_HOST_INFO(3)
Check Out this Related Man Page
MYSQL_GET_PROTO_INFO(3) 1 MYSQL_GET_PROTO_INFO(3)mysql_get_proto_info - Get MySQL protocol infoSYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_get_proto_info(3)
int mysql_get_proto_info ([resource $link_identifier = NULL])
DESCRIPTION
Retrieves the MySQL protocol.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns the MySQL protocol on success or FALSE on failure.
Example #1
mysql_get_proto_info(3) example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL protocol version: %s
", mysql_get_proto_info());
?>
The above example will output something similar to:
MySQL protocol version: 10
mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_server_info(3).
PHP Documentation Group MYSQL_GET_PROTO_INFO(3)
I am needing to "un-block" port 3306 so that I can access MySQL from another PC.
When I installed Mandrake 8.1, I set the security level to high because it is going to be a web server. I believe I have to allow access to my ports now and I do not know the commands to do that.
If anyone... (4 Replies)
While working with russian text under FreeBSD&MySQL I need to convert a string from MySQL to the Unicode format.
I've just started my way in C++ under FreeBSD , so please explain me how can I get ascii code of Char variable and also how can i get a character into variable with the specified ascii... (3 Replies)
I want to design a database, using mysql as a backend, and PHP as the frontend, I wanna be able to easily build forms in PHP to communicate with MySQL, is there any programs that will allow this, I really dont want to program all the forms by hand..
thankyou (2 Replies)
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
Hello,thanks for your help.
I can't connect my MYSQLserver , the note from my Linux System is 'Error 1130 (00000): Host 'my ip address' is not allowed to connect to this MySQL server. What could I do on this?
Thanks again! (4 Replies)
I've been running Django on MySQL on a Linux server for about 3 months w/o any problem. Suddenly a couple days ago, the server Django began throwing errors about not being able to connect to MySQL, at which point the entire server seizes up. The Apache Web server stops serving pages and SSH seizes... (3 Replies)
I am trying to learn how to install HORDE for work and I found this link:
Installing Horde on Centos 5.x - William Lindley - wlindley.com
I am at this step now:
You'll need to use the MySQL root password. Then, in your database administration screen for MySQL, set the password for the new... (2 Replies)
Hello,
I am new to UNIX and this is my first project with it.
I am trying to determine the best way to send information from a UNIX PHP website into a webservice.
I will have 4 variables to pass to it in an XML format.
I am not sure what exactly this would entail. If you could point me... (5 Replies)
Hi,
How to creating connection to mysql.I try to connect but the following error coming .How to solve it.
Could not connect to New MySQL.
Error creating SQL Model Connection connection to New MySQL. (Error: com.mysql.jdbc.Driver)
com.mysql.jdbc.Driver
Error creating JDBC Connection... (2 Replies)
Hello,
While I was interpretation the PHP manual on database security the recent past, it said that you should by no means connect to the database as the super user but rather as one more user with more limited options.
My question is:
How do you generate new users and set access... (2 Replies)
Hi,
I'm on a Raspberry Pi with Raspbian Wheezy.
I urgently need to get MySQL running with PHP, but I get an error.
For example:
$con=mysql_connect("127.0.0.1","root","******","ids");
gives
PHP Fatal error: Call to undefined function mysql_connect()
So, I found I needed to install some... (2 Replies)
Hi all,
Exactly like my title says.
I am learning PHP and MySQL and I used to use /var/www/ to host (contain or store) my files (.htm/.php) for testing. I could configure, finally, apache2 to use ~/public_html instead.
Now I when I tried to use $_SERVER it still directs (I used echo to show... (7 Replies)
I had a data folder in MySQL that has simply disappeared. Something about a compromised server and MySQL crashing. This happened a few days ago. Although there has been one reboot, nothing new has been written to the server, so I'm thinking in theory it might still be there.
Has anyone had... (2 Replies)