To get started with MYSQL
When you have installed the mysql server and mysqld python in your syste. Then its time to create the root password for mysql.
To create a root password for MySQL use the command:-
$ mysqladmin -u root password NEWPASSWORD
To change the password which is already used use the command:-
$ mysqladmin -u root -p’oldpassword’ password newpass
Now to create the database we should first login with mysql root :-
To login with root use the command :-
mysql -u root -p
which result showing 🙁
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.18 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. )
Here you have to enter the root password.
Then you can check the DATABASES with the command:-
To create database use the command :-
CREATE DATABASE (database name);
Now create a user for the database :-
CREATE USER ‘manuel’@’localhost’ IDENTIFIED BY ‘root’;