Getting Started: Dreamweaver vs Passwords
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]
Re: Getting Started: Dreamweaver vs Passwords
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. Once you've added a root passsword you'll need to add this to the config.inc.php (assuming you're running phpMyAdmin with conf option; the default behaviour) then reconnect to phpMyAdmin HTH Steve Davies -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting Started: Dreamweaver vs Passwords
At 02:57 PM 1/22/2004, David Blomstrom wrote: 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 or888-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]
Re: Getting Started: Dreamweaver vs Passwords
(Note: I've been having trouble with Eudora; I can receive mail, but I often can't send e-mails. So I resubscribed to the MySQL list from my other e-mail address, http://us.f604.mail.yahoo.com/ym/[EMAIL PROTECTED]YY=19813order=downsort=datepos=0view=ahead=b[EMAIL PROTECTED], but I haven't received any mail from the list here. Anyway, I haven't been able to get this message out, but here's another try!) At 12:17 PM 1/22/2004, Patrick Shoaf wrote: Once you've added a root passsword you'll need to add this to the config.inc.php (assuming you're running phpMyAdmin with conf option; the default behaviour) then reconnect to phpMyAdmin * * * * * * * * * * OK, I found the config.inc.php file, along with a tutorial at http://www.aota.net/PHP_and_MySQL/phpmyadmin.php4http://www.aota.net/PHP_and_MySQL/phpmyadmin.php4 It's an installation tutorial, but it looks like it can be applied to changing passwords, too. So it looks like I need to do the following: 1. Access the phpMyAdmin program configuration file. Are you referring to the page I get when I click Privileges, which lists all users, then I click Edit after Root/Local? It has a function named Change Password, but since I don't have a root password, I would go to Change Login Information, right? If so, which of the four choices should I choose under Create a new user with the same privileges? (I put a screen shot online at http://geowebworks.geobop.org/mysql/2.php;http://geowebworks.geobop.org/mysql/2.php; it's the last picture on the page.) 2. Follow the following instructions Change Login Information / Copy User 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. a. Create a password for User (Root), Host (localhost). I'm using holiday as an example for my password. b. Then open the config.inc.php file and change these two lines... $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] ='' to: $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] =''holiday * * * * * * * * * * However, there's apparently an alternative method, that may be better. Would you recommend Plan 2 (above), or one of the following (http or cookie)? Again, I'm the only administrator and user of MySQL on my computer, but I'll be publishing websites to the Internet: http or cookie authentication methods - These methods are more secure, as your username and password are not stored on the server in your configuration file. To use either of these methods, find the first occurrence of the following two lines in the config.php.inc file: $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] ='' And change them to: $cfgServers[$i]['user'] = ''; $cfgServers[$i]['password'] ='' Providing neither your password nor your username. Next, locate the first occurrence of the following line: $cfg['Servers'][$i]['auth_type'] = 'config'; And change it to either $cfg['Servers'][$i]['auth_type'] = 'http'; or $cfg['Servers'][$i]['auth_type'] = 'cookie'; 3. Reload the Privileges. (This is sort of like refreshing a page, and, if I'm not sure whether it needs to be done, I can do it anyway, as many times as I want, right?) 4. Do I need to restart my computer before the changes will take effect? Thanks! 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.