xamppにてmysqlを立ち上げ、ユーザを作成し、ログインするコマンド(mysql -u tennisuser -p)を打ち込んだのですが、実行結果の画面には何も表示されません。下記は、長くて申し訳ないのですが、コマンドプロンプトにて、ユーザ作成までに入力したコマンドになります。
ログインできない理由に関しまして、原因が分からない為、どなたかご助言頂けましたら幸いです。
よろしくお願いいたします
MariaDB [(none)]> CREATE DATABASE tennis; Query OK, 1 row affected (0.16 sec) MariaDB [(none)]> MariaDB [(none)]> use tennis Database changed MariaDB [tennis]> use tennis; Database changed MariaDB [tennis]> CREATE TABLE bbs( -> id INT NOT NULL AUTO _INCREMENT PRIMARY KEY, -> name VARCHAR(255) NOT NULL, -> title VARCHAR(255), -> body TEXT NOT NULL, -> date DATETIME NOT NULL, -> pass CHAR(4) NOT NULL -> )DEFAULT CHARSET SET=utf8; 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 'AUTO _INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, title VARCHAR(255), bod' at line 2 MariaDB [tennis]> CREATE TABLE bbs( -> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, -> name VARCHAR(255) NOT NULL, -> title VARCHAR(255), -> body DATETIME NOT NULL, -> PASS CHAR(4) NOT NULL -> )DEFAULT CHARACTER SET=utf8; Query OK, 0 rows affected (0.25 sec) MariaDB [tennis]> MariaDB [tennis]> GRANT ALL ON tennis.* to 'tennisuser'@'localhost' -> IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.01 sec) MariaDB [tennis]> FLUSH PRIVILEGES -> FLUSH PRIVILEGES; 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 'FLUSH PRIVILEGES' at line 2 MariaDB [tennis]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) MariaDB [tennis]> mysql -u tennisuser -p -> mysql -u tennisuser -p -> mysql -u tennisuser -p; 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 'mysql -u tennisuser -p mysql -u tennisuser -p mysql -u tennisuser -p' at line 1 MariaDB [tennis]> mysql -utennisuser -p -> mysql -u tennisuser -p -> mysql -u tennisuser-p -> mysql-u tennisuser-p -> mysql -utennisuser -p -> FLUSH PRIVILEGES -> FLUSH PRIVILEGES; 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 'mysql -utennisuser -p mysql -u tennisuser -p mysql -u tennisuser-p mysql-u tenni' at line 1 MariaDB [tennis]> mysql -u tennisuser -p -> mysql -u tennisuser -p -> password -> password: -> password; 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 'mysql -u tennisuser -p mysql -u tennisuser -p password password: password' at line 1 MariaDB [tennis]>
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2019/02/19 08:58
2019/02/19 09:00
2019/02/19 09:13