mysql -u root -p ->to login using root user CREATE DATABASE TESTDB; -> to create a new database, use this command. TESTDB is a dummy database. To use this database, command is use TESTDB -> by using “use Database_name” , we can access the Database_name. CREATE TABLE test_tbl (test_name VARCHAR(20), test_status VARCHAR(20) ); –> To create a tableContinueContinue reading “[Mysql] database access steps”
Category Archives: mysql
[Linux][Python][mysql]ImportError: No module named MySQLdb
Here is the solution for ImportError: No module named MySQLdb install python-mysqldb using the following command (ubuntu ) apt-get install python-mysqldb in Fedora use yum install instead of apt-get install.
[Mysql] Steps to create user
How to create user for mysql First login using root, mysql -u root -p Now change the database to mysql, use mysql Now create new user (test) using the following command , GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON TUTORIALS.* TO ‘test’@’localhost’ IDENTIFIED BY ‘test123’ ; So test user is created with test123 password …………………………………………………………………………………….
MyBeautifulWorld 