Exploring Flex

  • March 2018
    M T W T F S S
    « Jun    
  • web stats tracker
  • Advertisements

Posts Tagged ‘mysql’

Create new MySQL user

Posted by hneelu on February 18, 2009

There are more ways how you can do this.
* Using CREATE USER and/or GRANT commands
* Inserting a new record into the mysql.user table

Note: This command is available only in MySQL 5 (5.0.2) and newer releases.
Syntax is :

CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';

CHECK : mysql.user table has a new record in it.
NOTE: All privileges are set to No so this user can do nothing in the DB.
To add some privileges we can use the GRANT command as follows:


To add all priviliges to the user you don’t have to list all of them but you can use the ALL shortcut as follows:

GRANT ALL ON *.* TO 'user1'@'localhost';

You can create a new MySQL user in one step as well using again the GRANT command with a small extension as here:

GRANT ALL ON *.* TO 'user2'@'localhost' IDENTIFIED BY 'pass1';

Inserting a new record into the mysql.user table
In this case you just inserts a new record into the table with a normal INSERT command:

INSERT INTO user (Host,User,Password)

Or you can add some priviliges as well in a form like this:

INSERT INTO user (Host,User,Password,Select_priv,Insert_priv)


Posted in mysql | Tagged: , , | Leave a Comment »

Creating a new password for MySQL

Posted by hneelu on February 18, 2009

When you set up WAMP/MySQL it will leave the password to blank and the user name ‘root’.

Log into mysql monitor – I gave details above. Or you can simple use the Wamp menu (in the icon tray in the Windows start bar) and
select: MySQL -> MySQL console.
With WAMP, do not enter password. Just hit enter and you will be logged in:

Use this command to reset the root password:
mysql> SET PASSWORD FOR root@localhost=PASSWORD('your_password');

Posted in mysql | Tagged: , , | Leave a Comment »

Reset password in WAMP server

Posted by hneelu on February 18, 2009

Go to Command Prompt

[To find the proper folder, go into your wamp folder using Windows Explorer, click “bin”, “mysql”, then find where the other “bin” folder is under that.]

In the command promt type :
mysqladmin -u root password NEWPASSWORD
where NEWPASSWORD is the new password.

Posted in mysql | Tagged: , , | 8 Comments »