Wamp 5

howdydoody

howdydoody

howdydoody

Permabanned
Joined
4 Nov 2007
Posts
180
Hi all,

Just downloaded WAMP5 to my work PC so I can have a play about until I get home and set it up properly.

Now I have never used anything like this but it's been rather simple to set up.

I have also downloaded Zencart, however it requires a DBase to already of been setup. Oh-o, time for MySQL. Well, Wamp 5 a MySQL console and a visual browser called SQLiteManager.

Ive been having a read of various sites about MySQL, and it seems that SQLiteManager has something disabled, others added.

Am I better to use a MySQL command line to edit tables etc? bearing in mind I am completely new and find the visual side eaier to use. Or are there other, better visual based editors out there?

Any help, info, links gratefull received :D

I am sure I will have many more questions in this thread over the next week!

EDIT: I need to make a product table, do I have to start from scratch or can I import the info in an excel/openoffice spreadsheet?
 
I've got WAMP but I've never used SQLiteManager since phpMyAdmin is also included. I think MyPHPAdmin will let you import CSV files, if you not you can probably use the Concatenate function in your spreed sheet to produce SQL code to wirte you data into MySQL.
 
I totally missed phpMyAdmin, Do'h :)

how easy would it be to stick WAMP5 on the crappy little old XP PC I have sitting around, connect it to my Netgear DG834G ROUTER and use it as a remote server, file storage for access from the LAN and the internet?
 
Ive got home, downloaded WAMP5 and Zencart, installed WAMP5 and encountered my first problem:

Install WAMP5 to recommended destination ( C:/wamp/ )
Put wamp server online.
Turn on php_curl and apache SSL_module (Zencart needs them)
Open phpMyAdmin

It tells me at the bottom of the screen :

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
Click to expand...

Guessing I thought the answer would be to add a password to the root account, so I went to privileges, edit root, and changed the password.

All I get then is:

Welcome to phpMyAdmin 2.10.1

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Click to expand...

how do I fix it?
 
You must log in or register to reply here.
Back
Top Bottom