[mysqld]
basedir=C:/mysql
#bind-address=192.168.0.20
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-opt.exe
user=admin
password=admin007
这个是my.ini的信息
basedir=C:/mysql
#bind-address=192.168.0.20
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-opt.exe
user=admin
password=admin007
这个是my.ini的信息
服务安装了吗?服务启动了吗?
密码默认为空,连接看看
Server=C:/mysql/bin/mysqld-opt.exe
这里错了,应该是
Server=C:/mysql/bin/mysqld-nt.exe
$MYSQL_USERNAME = "root";
$MYSQL_PASSWORD = ""; $DATABASE = "数据库"; mysql_connect($MYSQL_HOSTNAME, $MYSQL_USERNAME, $MYSQL_PASSWORD);
mysql_select_db($DATABASE) or die(mysql_error());
$dbhost="41-607";
$dbuser="admin";
$dbpasswd="admin007";
$db="diary";
$time=date("Y-n-j")
?>
根本就没有连接啊老大
用mysql_connect(),或者mysql_pconnect()才是连接啊
require ("config.php");
$my_conn=@mysql_connect($dbhost,$dbuser,$dbpasswd) or die ("数据库连接失败");
?>
$dbhost="你的ip";
$dbuser="admin";
$dbpasswd="admin007";
$db="diary";
mysql_connect($dbhost, $dbuser, $dbpasswd);
mysql_select_db($db) or die(mysql_error());
?>
数据库连接失败
$dbhost="你的ip";
$dbuser="admin";
$dbpasswd="admin007";
$db="diary";
mysql_connect($dbhost, $dbuser, $dbpasswd);
mysql_select_db($db) or die(mysql_error());
?>
提示:
Warning: mysql_select_db(): Access denied for user 'ODBC'@'localhost' (using password: NO) in H:\php\diary\Diarys.php on line 17Warning: mysql_select_db(): A link to the server could not be established in H:\php\diary\Diarys.php on line 17
数据库连接失败
mysql>set password for
>'admin'@'localhost' = OLD_PASSWORD('newpassword');Mysql 4.0以上版本的password算法是新的,不是以前的16位密码,所以会出现密码错误的提示。
安装PHP5?
>'admin'@'localhost' = OLD_PASSWORD('newpassword');是在哪执行???
步骤.....谢谢.....
C:\Mysql>cd bin
C:\Mysql\bin>mysql -uadmin -p
Enter password:******** //输入admin的密码成功后显示一段信息,然后变成
mysql>set password for
>'admin'@'localhost' = OLD_PASSWORD('newpassword');所有的换行,都代表按回车,newpassword是你的admin 的密码
require ("config.php");
$my_conn=@mysql_connect($dbhost, $dbuser, $dbpasswd) ;?>
<?
if($del!=""){
$db1 ="Delete From diary Where id=".$del;
mysql_db_query( $db,$db1);
header("location:Diarys.php");
};?>
<html>
<head>
<title>会写程序的鸟</title><META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="style.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
body {
background-color: #F3F3F3;
margin-left: 10px;
margin-top: 2px;
}
.style1 {color: #5C656F}
-->
</style></head>
<body>
<?
$db1= "select * from diary order by id desc";
$sql=mysql_db_query( $db,$db1);
while($row=mysql_fetch_array($sql)){
$title=$row[title];
$id=$row[id];
$content=$row[content];
$date=$row[date];
$images=$row[images];
?>
$username = "admin"; //用户名
$password = "admin777"; //用户密码
$database = "db_name"; //数据库名称 $conn = mysql_connect($host,$username,$password) or die (mysql_error());
mysql_select_db($database) or die(mysql_error());
?>使用
<?php require_once "Config.inc.php"; $sql = "select * from table ORDER by id ASC"; //SQL语句
$result = mysql_query($sql,$conn); while($row = mysql_fetch_assoc($result)){
echo $row['id']; //id、**为table表的字段
echo $row['**'];
......
} mysql_close($conn); //关闭Mysql连接?>
将$cfg['PmaAbsoluteUri']设置为你访问phpMyadmin的URL路径