I recently installed a preconfigured package with Apache, PHP and MySQL from "Apache Friends" (XAMPP). It seems to be a pretty slick package, and I got all three programs up and running without too much trouble. Now I'm beginning to learn about MySQL.

I finally got MySQL connected to Dreamweaver, but it was hardly a star effort.

I read a tutorial at
http://www.macromedia.com/support/dreamweaver/ts/documents/mysql_config.htm, but it's really confusing. Another problem is that this tutorial requires you to create a password for the root user. I did that twice - once from the Windows Command Prompt, then through phpMyAdmin. Each time, it knocked out phpMyAdmin, and I had to reinstall everything from scratch. So I'm finished with the root password.


In fact, I've been unable to create a password for any existing user. Every time I try to connect as any existing user, I get the error message Access Denied - Using a Password (No); or Using a Password (Yes), depending on whether I type in a fictitious password.

I couldn't create a password until I created a new user, which I was finally able to connect to Dreamweaver. But if the "root" user controls everything, then will I eventually have to connect it to Dreamweaver? If so, is there a way to connect it without a password?

I'm not administering MySQL for other people. At the moment, I'm just using it on my computer. My websites are hosted by an ISP. I don't yet understand how MySQL works online, but it sounds like ISP's have a sort of master account, which any accounts I create will operate within, right? So if I create three new users named One, Two and Three, and publish them online, the Root user will be whatever the ISP set up?

My MySQL program is installed in the following folder: C:/xampp/mysql/

I put some screenshots from phpMyAdmin online at
http://geowebworks.geobop.org/mysql/ and
http://geowebworks.geobop.org/mysql/2.php

Thanks.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to