Tuhinga Tuhinga
MySQLMe pēhea te hanga pātengi raraunga?hangapātengi raraunga MySQLWhakahau/Tauatau/Waituhi
MySQL hanga pātengi raraunga
Waihangahia he pātengi raraunga mā te whakamahi mysqladmin
Ma te kaiwhakamahi noa, ka hiahia pea koe ki nga mana motuhake ki te hanga, ki te whakakore ranei i nga papaa raraunga MySQL.
Na ka whakamahi matou i te kaiwhakamahi pakiaka ki te takiuru ki konei Ko te kaiwhakamahi pakiaka te mana teitei ka taea te whakamahi i te tono mysql mysqladmin ki te hanga i tetahi papaa raraunga.
Akoranga
Ko te whakahau e whai ake nei e whakaatu ana i te tukanga o te hanga i tetahi papaa raraunga ko chenweiliang:
[root@host]# mysqladmin -u root -p create chenweiliang Enter password:******
I muri i te whakahaerenga angitu o te whakahau i runga ake nei, ka hangaia te chenweiliang pātengi raraunga MySQL.
Waihangahia te papaunga raraunga ma te whakamahi i te tuhinga PHP
Ka whakamahi a PHP i te mahi mysqli_query ki te hanga, ki te muku ranei i nga papaunga raraunga MySQL.
E rua nga tawhā o te mahi ka whakahoki i te TRUE mena ka angitu te mahi, ki te kore ka hoki mai te HERE.
wetereo
mysqli_query(connection,query,resultmode);
Parapeta | whakaahuatanga |
---|---|
hononga | E hiahiatia ana.Ka tohua te hononga MySQL hei whakamahi. |
uiui | E hiahiatia ana, ka tohua te aho uiui. |
aratau hua | Kōwhiringa.he tuturu.Ka taea tetahi o nga uara e whai ake nei:
|
Akoranga
Ko te tauira e whai ake nei e whakaatu ana i te whakamahinga o te PHP ki te hanga i tetahi papaunga raraunga:
hanga pātengi raraunga
<?
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);
?>
Whai muri i te mahi angitu, ka whakahokia nga hua e whai ake nei:
i angitu te hononga
I pai te hanga o te chenweiliang pātengi raraunga
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "Me pehea te hanga a MySQL i te papaunga raraunga?Waihangahia nga Tono Raraunga Raraunga MySQL/Whakaahua/Waituhi" hei awhina i a koe.
Nau mai ki te tohatoha i te hono o tenei tuhinga:https://www.chenweiliang.com/cwl-459.html
Nau mai ki te hongere Telegram o te blog a Chen Weiliang ki te tiki i nga korero hou!
📚 He uara nui tenei aratohu, 🌟He waahi onge tenei, kaua e ngaro! ⏰⌛💨
Tohaina me te pai ki te pai koe!
Ko to tiritiri me o hiahia ko to maatau hihiri tonu!