WampServer

I installed Wamp and created a password for the MySQL database. In doing so the breaks the myPHPAdmin link UNLESS I apply a password to that as well.

In attempting to apply a password to myPHPAdmin I follow the steps below but still get nothing :/ Can someone please tell me what I'm doing wrong?

1. Go to Apps dir > myphpadmin folder > config.inc
2. in config.inc I have the following:

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

THIS did not work despite forum #1 I read so I tried this (adding password line):

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['password'] = myactualpassword212;
$cfg['Servers'][$i]['AllowNoPassword'] = false;


Also when I get in without a password it does not let me create a database... can this be fixed once password is issued or is that a whole different issue?

Please Help :/

UNDO ALL YOUR CHANGES.

You are using wamp server 2.4 by the looks of it.
In 2.4 phpmyadmin is designed to show a login screen.

Unless you changed something ....


USERID = root
PASSWORD = (Nothing, Empty, Blank, Nichego, Pustoy, Nada, No-Value )

Thanks for reply.

I undid my changes to default and that is the following:

/*
* First server
*/
$i++;
/* Authentication type */

$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;


/*
* phpMyAdmin configuration storage settings.
*/

Where do I put in user and id? If in the login screen, I tried that and still cannot create database (No privledges)

If in config file, there is no place that reads :UserID" or "Password"

When you click on phpMyAdmin on the wampmanager menu you get to this screen



just click the Go button as there is no password set bt default.

Now you get to this page



Click on the database tab

Now enter a name for your new database in here



That shoudl create a new database for you



Edited 1 time(s). Last edit at 07/03/2013 10:29PM by RiggsFolly.

Thank you for taking your time for the screen shots. When I am in the Database tab it reads

Create Database:
No Privledges

And therfore will not let me create database. This is what I need solution for :/

Also, when I click on little question mark next to No Privledges I get this link that opens:

[dev.mysql.com]

OK, now I understand.

What happens if you use this address to access phpmyadmin?

http://127.0.0.1/phpmyadmin

Then login as before and try to create a database.

That address takes me to the same phpadmin login screen. (where I still cannot create a database "no privledges"

Can I just clarify:

Please answer all the questions.


You changed the password of the mysql account called 'root' ? YES /NO

When you get to the Login page you are entering Username = root and password = YOUR NEW ONE? YES/NO

What happens if you login using Username = root and password = 'Leave it blank'?



IT MAY BE EASIER IF YOU :

Install TeamViewer and I will troubleshoot for you.

Install TV, then run it.

Do this before attempting a connection.

How to Configure Team Viewer so it does not require port 80 or 443

Run TV
Extras -> Options -> Advanced -> Press the Advanced Button -> Advanced Network Connections

Check the checkbox saying [ Dont use incomming port 80 (recommended for web servers only ) ]
Stop and restart TV.

Then
Send me a Private Message containing the TV ID and PASSWORD so I can connect.
Leave TV running as it will change the password each time you restart it.

Hi,

I actually re-installed Wamp but still no luck. This time I did not add a password to anything (yet).

So, can we please start from scratch?

I am able to get files from localhost, so that's working. But in myphpadmin I am not able to login with out a Username (although) I have not set one.

I tried loging in with username as "host" and it does let me in BUT still "no privledges" to create a database.

Did you uninstall and then delete all the c:\wamp folder and below. Uninstall wont remove files that you have changed.


So if not do that.


Then when you come to phpMyAdmin, use a Username of root. Thats the username that is setup in mysql by default.

Yes, everything was completely uninstalled from folder and program files. After installing a fresh wampserver I was able to log in to myphpadmin but as I described above, it let me log in with "host" as username but still does reads "no privledges" when attempting to create database.

Is there a way I can attach images to these posts so i can show you my screenshot? If that would help :/

For heaven sakes,

There is NO User named host setup by default in a vanilla MySQL.


There IS a user named 'root'


User the 'root' Username with an empty password and phpMyAdmin will work properly.


I have no idea why it lets you in with 'host' as a username but basically DONT USE IT

lol, awesome. Thank god for people like ME to keep you on your toes Either way... Thank You SO much for all your quick responses and help!

hehe,

Just glad I finally twigged it. I Apologise for the slightly curt last answer.

No problem. I know how it i when something is so simple (to me) and others just don't get it, lol. This is how we learn and understand "common" beginner issues. Again, thanks. I can't say this will be the last you'll hear from me

Looking forward to it already!

Hello It's ME again.

After creating the DB on local server and exporting the live DB SQL from love server I am now trying to IMPORT

the existing live DB into the local server DB and I am getting the following error and have no idea why or where to go to even try to fix anything.

Error
SQL query:

--
-- Database: `artattac_aafxwp`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_cf7dbplugin_submits`
--
CREATE TABLE IF NOT EXISTS `wp_cf7dbplugin_submits` (

`submit_time` DECIMAL( 16, 4 ) NOT NULL ,
`form_name` VARCHAR( 127 ) CHARACTER SET utf8 DEFAULT NULL ,
`field_name` VARCHAR( 127 ) CHARACTER SET utf8 DEFAULT NULL ,
`field_value` LONGTEXT CHARACTER SET utf8,
`field_order` INT( 11 ) DEFAULT NULL ,
`file` LONGBLOB,
KEY `submit_time_idx` ( `submit_time` ) ,
KEY `form_name_idx` ( `form_name` ) ,
KEY `field_name_idx` ( `field_name` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation

#1046 - No database selected

At the top of the file you are trying to IMPORT add this line

USE `artattac_aafxwp`;

The error is telling you that it does not know which database it should import the new tables and data into.

Remember MySQL is a Database Manager i.e. not just a single database like 'Access' but a tool that managers MULTIPLE databases. You therefore have to tell it which one you are importing to.... even if you only have one.


Also you must make sure that the `artattac_aafxwp` database actually exists before trying the import again.
So create it using phpMyAdmin.

Thank you SO MUCH. That did the trick!