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.
Password are a very funny issue. When adding users & allowing access to databases & table, you have to be very careful, as you found out, you can break things quickly.
Here are a few items to help you...
1) after adding a new user, on the privileges page, try issuing a reload (very last line on the page has a link). You need to reload, flush, the users table to make users visible to the world.
2) when changing the password for root, make sure you have access to the phpMyAdmin program configuration file. You will need to set the new root password there, or configure phpMyAdmin to ask for the username/password.
3) DreamWeaver will access the mySQL using root with no password, but that is frowned on by all. Anyone would have full access to mySQL and be able to create havoc for you.
4) If an ISP is hosting you MySQL data, then you will be issued usernames/passwords to access MySQL, most ISP's do not provide you a dedicated MySQL Server with root access.
Hope this helps some...
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]
Patrick J. Shoaf, Systems Engineer <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or 888-638-6963 Fax: 724-489-4386
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
