Exploring Flex

Posts Tagged ‘wamp’

Q. You don’t have permission to access /phpmyadmin/ on this server

Posted by hneelu on February 20, 2009

I have installed wamp on machine A. When I am on the local server that I installed it on I can access PHPMyAdmin from http://127.0.0.1/phpmyadmin or http://localhost/phpmyadmin
But I want to be able to access it from my computer and when I type in IP address of the Server I can see the pages I have put in but when I type http://192.168.0.3/phpmyadmin, PHPMyAdmin comes up saying
Forbidden
You don’t have permission to access /mysql/ on this server.

Solution:
Go to C:\wamp\alias. Open the file phpmyadmin.conf and add

Options Indexes FollowSymLinks MultiViews
Allow Override all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
Allow from MACHINE_IP

Advertisements

Posted in wamp | Tagged: , | 73 Comments »

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');

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 »