리눅스마스터1급 : MySQL(MariaDB) 데이터베이스 연동 테스트를 위한 DB 및 사용자 생성

[root@RockyLinux01 ~]# mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 5

Server version: 10.5.16-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

MariaDB [(none)]>

MariaDB [(none)]> create database sulinux;

Query OK, 1 row affected (0.000 sec)

MariaDB [(none)]>

MariaDB [(none)]> grant all privileges on sulinux.* sulinux@localhost identified by '11111111' with grant option;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'sulinux@localhost identified by '11111111' with grant option' at line 1

MariaDB [(none)]>

MariaDB [(none)]>

MariaDB [(none)]> GRANT ALL PRIVILEGES ON sulinux.* TO sulinux@localhost IDENTIFIED BY '비밀번호' WITH GRANT OPTION;

Query OK, 0 rows affected (0.008 sec)

MariaDB [(none)]>

MariaDB [(none)]> flush privileges;

Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]>

<?php

echo "DB Connect<BR>";

$mysql = mysql_connect("localhost", "sulinux", "비밀번호") or die("DB Connect Faied");

echo "Select sulinux DB<BR>";

$status = mysql_select_db("sulinux",$mysql);

echo "Create sutable table<BR>";

$result = mysql_query("CREATE TABLE sutable ( a text )",$mysql);

echo "Insert data<BR>";

$result = mysql_query("INSERT INTO sutable VALUES('DataBase Test')",$mysql);

echo "Select data<BR>";

$result = mysql_query("SELECT * FROM sutable",$mysql);

echo "Fetch data<BR>";

$row = mysql_fetch_array($result);

echo "Result : <FONT color=red>".$row["a"]."</FONT><BR>";

echo "Drop sutable table<BR>";

$result = mysql_query("DROP TABLE sutable",$mysql);

?>