在网上找到几个测试mysql的命令。
C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow
C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow -u root mysql
C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin version status proc
C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql test 使用后得到的信息是
mysqlshow: Access denied for user 'ODBC'@'localhost' (using password: NO)还请版主指点
C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow
C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow -u root mysql
C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin version status proc
C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql test 使用后得到的信息是
mysqlshow: Access denied for user 'ODBC'@'localhost' (using password: NO)还请版主指点
输入你的root密码~
Enter password: ******
+--------------------+
| Databases |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+是否正常
Enter password: ******
Database: mysql
+---------------------------+
| Tables |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| servers |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
这个是显示你mysql存在的数据库
默认安装完 就是这3个库~
数据库运行正常但是php无法连接<?php
$mysql_server_name='localhost';
$mysql_username='root';
$mysql_password='12345678';
$mysql_database='mycounter';
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
$sql='CREATE DATABASE mycounter DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
';
mysql_query($sql);
$sql='CREATE TABLE `counter` (`id` INT(255) UNSIGNED NOT NULL AUTO_INCREMENT ,`count` INT(255) UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY ( `id` ) ) TYPE = innodb;';
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
//echo $sql;
mysql_close($conn);
echo "Hello!数据库mycounter已经成功建立!";?>
测试的回复信息是
Warning: mysql_connect() [function.mysql-connect]: [2002] 由于连接方在一段时间后没有正确答复或连接的主机没有反应,连接尝试 (trying to connect via tcp://localhost:3306) in D:\IIS root\phpweb\mysqllink.php on line 6Warning: mysql_connect() [function.mysql-connect]: 由于连接方在一段时间后没有正确答复或连接的主机没有反应,连接尝试失败。 in D:\IIS root\phpweb\mysqllink.php on line 6Fatal error: Maximum execution time of 30 seconds exceeded in D:\IIS root\phpweb\mysqllink.php on line 6phpinfo()可以运行
我已经知道怎样使用mysql命了经测试代码的localhost 修改为127.0.0.1就可以了。
原因不明。请高手给出原因,我就结贴。
已经有了 localhost 127.0.0.1
但还是不行最后删了php5.3,又换回 php5.2 就OK了, 又可以用localhost了所以应该是PHP版本的问题