Click to See Complete Forum and Search --> : Setting up phpmyadmin, not sure how to configure


chrismgtis
05-19-2009, 01:08 AM
I'm attempting to setup phpMyAdmin 3.1.5 with MySQL 5.1 with PHP 5.2.9 on Windows Vista with the newest Apache server.

I've got PHP and MySQL successfully installed. I'm just not sure how to setup phpMyAdmin. I used the web configuration, but I'm not sure what to put in all the fields.

This SQL server is only for development purposes. I'm writing a PHP application and just using the MySQL server as a database for the application. The application will eventually be moved to a web host with an entirely new database.

I've got the following in Edit Server.

Verbose name of this server: localhost
Server hostname: localhost
Server port: empty
Server socket: empty
Use SSL: not checked
Connection type: TCP
PHP extension to use: mysql
Compress connection: no
Authentication type: cookie
User for config auth: blank
Password for config auth: blank
Connect without password: no

I'm not sure if I should put anything in the other tabs.

I have a database that I created called myth and I created a user account called chrisgrooms. I don't know how to allow chrisgrooms to access myth or how to assign a user/pass to the myth database.

chrismgtis
05-19-2009, 02:54 AM
Well, I seem to have fixed that and 5 other problems I came up on.

:mad:

If I log in as root, Apache would crash. If I logged in under an account I created for myself, it wouldn't.

You know, if I don't get rich eventually off computers after dealing with this kind of nonsense for 15 years, I can count my life as a failure.

Ok, it still crashes randomly. I can't get back in at all.

lolito
05-21-2009, 03:05 AM
I'm attempting to setup phpMyAdmin 3.1.5 with MySQL 5.1 with PHP 5.2.9 on Windows Vista with the newest Apache server.

I've got PHP and MySQL successfully installed. I'm just not sure how to setup phpMyAdmin. I used the web configuration, but I'm not sure what to put in all the fields.

This SQL server is only for development purposes. I'm writing a PHP application and just using the MySQL server as a database for the application. The application will eventually be moved to a web host with an entirely new database.

I've got the following in Edit Server.

Verbose name of this server: localhost
Server hostname: localhost
Server port: empty
Server socket: empty
Use SSL: not checked
Connection type: TCP
PHP extension to use: mysql
Compress connection: no
Authentication type: cookie
User for config auth: blank
Password for config auth: blank
Connect without password: no

I'm not sure if I should put anything in the other tabs.

I have a database that I created called myth and I created a user account called chrisgrooms. I don't know how to allow chrisgrooms to access myth or how to assign a user/pass to the myth database.

Actually I didn't change the configuration phpMyAdmin if the server is in Hard Drive unless if the server is in web hosting. I'm just leave as Default Configuration because it is very hard to access the database in that server if I change the configuration.