mysql/php创建数据库、表

1. php: MySQL:

1、默认是"root/"，密码为空，登录时mysql.exe --user=root [--password=chuqingq] MySQL

或者mysql -uroot -p123

2、创建用户，create user chuqq identified by 'chuqingq'

3、连接时不能用localhost，会使用明明管道，如果明确用tcp/ip，则使用127.0.0.1

Note: Whenever you specify "localhost" or "localhost:port" as server, the MySQL client library will override this and try to connect to a local socket (named pipe on Windows). If you want to use TCP/IP, use "127.0.0.1" instead of "localhost". If the MySQL client library tries to connect to the wrong local socket, you should set the correct path as in your PHP configuration and leave the server field blank. 

4、使用mysql_connect连接

现在使用的账号是root/chuqingq, chuqq/chuqingq

5、给chuqq赋予所有权限，以创建数据库

grant all on *.* to 'chuqq'@'%';

6、创建数据库

CREATE DATABASE IF NOT EXISTS test_db

7、选择数据库

use test_db/mysql_select_db('test_db', $link)

 

 

 

<?php

// 连接

$link = mysql_connect('127.0.0.1', 'chuqq', 'chuqingq');

if (!$link) {

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully\n';

 

// 把数据库的权限赋给chuqq

// grant all on *.* to 'chuqq'@'%';

 

// 选择数据库

if (!mysql_select_db('test_db', $link)) {

die("mysql_select_db error" . mysql_error());

}

echo "test_db selected\n";

 

// 创建数据库

if (mysql_query('CREATE DATABASE IF NOT EXISTS test_db')) {

echo "test_db created\n";

} else {

// Can't create database 'test_db'; database exists

// Access denied for user 'chuqq'@'%' to database 'test_db' 需要把数据库的权限赋给用户

die("create test_db error\n" . mysql_error());

}

 

// 创建新表

if (mysql_query('CREATE TABLE IF NOT EXISTS test_table(ID int, DATA varchar(15))')) {

echo "test_table created\n";

} else {

die("create test_table error\n" . mysql_error());

}

 

// 插入数据

if (mysql_query('INSERT INTO test_table(ID, DATA) VALUES(1, "11111")')) {

echo "test_table inserted\n";

} else {

die("insert test_table error\n" . mysql_error());

}

 

// 查询数据

if ($results = mysql_query('SELECT * FROM test_table')) {

echo "test_table SELECTED\n";

print_r(mysql_fetch_array($results));

} else {

die("SELECT test_table error\n" . mysql_error());

}

 

mysql_close($link);

?>