E faʻapefea ona fatuina e MySQL se faʻamaumauga?Fausia MySQL database command/statement/syntax

MySQLFa'afefea ona fai se fa'amaumauga?faiaMySQL databasePoloaiga/Fa'amatalaga/Syntax

MySQL fatuina faʻamaumauga

Fausia se faʻamaumauga e faʻaaoga ai mysqladmin

Faatasi ai ma se tagata faʻaoga masani, atonu e te manaʻomia ni avanoa faʻapitoa e fatuina pe tape ai MySQL databases.

O lea matou te faʻaogaina le root user e saini ai iinei.O le root user e iai le pule sili ona maualuga ma e mafai ona faʻaaoga le mysql mysqladmin command e fatu ai se database.

Fa'ata'ita'iga

O le faʻatonuga lea e faʻaalia ai le faʻagasologa o le fatuina o se faʻamaumauga e igoa ia chenweiliang:

[root@host]# mysqladmin -u root -p create chenweiliang
Enter password:******

A maeʻa le faʻatonuga o loʻo i luga ma le manuia, o le a faia le MySQL database chenweiliang.

Fausia faʻamaumauga e faʻaaoga ai le PHP script

PHP faʻaaoga le mysqli_query galuega e fatu pe tape MySQL databases.

O le galuega e lua taʻiala ma toe faʻafoʻi le TRUE pe a manuia le faʻatinoga, a leai e toe foʻi mai le FALSE.

kalama

mysqli_query(connection,query,resultmode);

Fa'ata'ita'iga

O le faʻataʻitaʻiga o loʻo i lalo o loʻo faʻaalia ai le faʻaogaina o le PHP e fatu ai se faʻamaumauga:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接错误: ' . mysqli_error($conn));
}
echo '连接成功
';
$sql = 'CREATE DATABASE chenweiliang';
$retval = mysqli_query($conn,$sql );
if(! $retval )
{
 die('创建数据库失败: ' . mysqli_error($conn));
}
echo "数据库 chenweiliang 创建成功\n";
mysqli_close($conn);
?>

A mae'a fa'ataunu'u manuia, e toe fa'afo'i mai i'uga nei:

manuia fesootaiga

O le database chenweiliang na faia ma le manuia