{{theTime}}

Search This Blog

Total Pageviews

MySql Startup............

Prerequisite: Install mysql

How to create user name & permissions???

Login: mysql -u root -p
Enter password: admin

mysql> create user 'sri'@'localhost' identified by sri
mysql> grant all permissions on *.* to sri@localhost
mysql> mysqladmin -u sri -p create my_first_database

How to Shutdown mysql: mysqladmin -u root shutdown
Listen to this article

Listen to this article

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...