gudii9
asked on
mysql database, schema and table creation
hi,
I just installed mysql and mysql workbench. I have mysql command client also installed. I have basically skipped step of installing python and completed everything as it says manual and not able to browse to python while installing.
now my question is from command line client how to create new database, schema and table?
i tried below
mysql> mysqladmin -u root -p create TUTORIALS
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin -u root -p create TUTORIALS' at line 1
as given below
https://www.tutorialspoint.com/mysql/mysql-create-database.htm
did not work
how to create new database, schema and table etc using mysql work bench?
please advise
I just installed mysql and mysql workbench. I have mysql command client also installed. I have basically skipped step of installing python and completed everything as it says manual and not able to browse to python while installing.
now my question is from command line client how to create new database, schema and table?
i tried below
mysql> mysqladmin -u root -p create TUTORIALS
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin -u root -p create TUTORIALS' at line 1
as given below
https://www.tutorialspoint.com/mysql/mysql-create-database.htm
did not work
how to create new database, schema and table etc using mysql work bench?
please advise
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how to start mysql database.
i think i created database, schema and table as well
i tried as below gives error
mysql> mysqld.exe
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqld.exe' at line 1
mysql>
i think i created database, schema and table as well
i tried as below gives error
mysql> mysqld.exe
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqld.exe' at line 1
mysql>
ASKER
from command prompt i tried below which does not work either
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld"
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld"
ASKER
when i say below command
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| gpmysqldb |
| mysql |
| performance_schema |
| sakila |
| student |
| sys |
| user_schema |
| world |
+--------------------+
9 rows in set (0.00 sec)
it shows all those databases. does that mean my database is up and running?
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| gpmysqldb |
| mysql |
| performance_schema |
| sakila |
| student |
| sys |
| user_schema |
| world |
+--------------------+
9 rows in set (0.00 sec)
it shows all those databases. does that mean my database is up and running?
The documentation is your friend -> https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
Given the output you are getting, I would say that it is running.
Given the output you are getting, I would say that it is running.
Technically, your DBMS (Database Management System) is "up and running". If the database you thought you had created is one of those listed in the output of "show databases",, then it too is "up and running".
There is a distinction between a "database" and a "DBMS".
There is a distinction between a "database" and a "DBMS".
ASKER
i see my DB there
gpmysqldb
so when i start laptop mysql automatically start? no need to start manually? how to configure to start manually?
gpmysqldb
so when i start laptop mysql automatically start? no need to start manually? how to configure to start manually?
go into services and change the startup from automatic to manual.
You can reach services via control panel -> administrative tools -> services
You can reach services via control panel -> administrative tools -> services
ASKER
i went here and saw mysql as automatic runing. how to change to manual. i right clicked i see options like stop but not manual please advise
>> how to change to manual.
Right click, select Properties. Then startup options.
Right click, select Properties. Then startup options.
ASKER
https://www.pantz.org/software/mysql/mysqlcommands.html