Exploring Flex

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

CREATE USER command
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:

GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost';

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)
VALUES('localhost','user3',PASSWORD('pass3'));

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

INSERT INTO user (Host,User,Password,Select_priv,Insert_priv)
VALUES('localhost','user4',PASSWORD('pass3'),'Y','Y');

Advertisements

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
C:\wamp\bin\mysql\mysql5.0.51b\bin

[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 »

Native ActionScript APIs

Posted by hneelu on April 2, 2008

I found a guide which provides a reference for all native ActionScript APIs for the Adobe technology platform runtimes, Adobe Flash Player and Adobe AIR, as well as Flex framework APIs.

The guide is here.

Simply leaf through the guide using class/interface name as reference. Each entry contains  information such as name of the item, package name, superclass, interface implemented as well as complete APIs listing (instance properties and methods).

W3Counter

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