Link to home
Start Free TrialLog in
Avatar of gudii9
gudii9Flag for United States of America

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
SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gudii9

ASKER

ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gudii9

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>
Avatar of gudii9

ASKER

from command prompt i tried below which does not work either
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld"
Avatar of gudii9

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?
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.
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".
Avatar of gudii9

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?
go into services and change the startup from automatic to manual.

You can reach services via control panel -> administrative tools -> services
Avatar of gudii9

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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>> how to change to manual.

Right click, select Properties.  Then startup options.