How to Create Database in Mysql

How to Create Database in Mysql

Login to your mysql server through console remote shell(putty)

If you want to create a database name = mytestdb and grant permission for user = testuser with password = testpasswd
database name = mytestdb
User Name = testuser
Password  = testpasswd

#mysql -u root -p ( enter the mysql root password)
mysql> create database mytestdb;
mysql> grant all privileges on mytestdb.* to testuser@localhost identified by 'testpasswd';
mysql> FLUSH PRIVILEGES;
mysql>show databases;
mysql> exit

This will create mytestdb and enable access for testuser form localhost
If you want to connect mysql form remote server, then replace localhost with your remote server ip



Risk Involved, Apply on your risk.

IIS Manager is not showing anything

Platform : IIS 6.0
Operating Environment : Windows server 2003 SP2
Installed Components : IIS 6.0

Problem Description :
You are not able to view website/ftp etc from IIS console, Resetting IIS wont fix the problem. Also you may get an error "the path specified cannot be used at this time"

In the Event Viewer you may find following error

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: (964)
Event ID: 6398 


ReSolution: - Bug can be fix by applying a hotfix available from Microsoft. This hotfix will update the adsi.dll file from its older version and will resolve the issue permanently.
Please refer to KB article http://support.microsoft.com/kb/946517 for more details.

Applying hotfix may change settings in registry etc risk involved.