12-25-2006, 11:55 PM
Help! I installed MySql and PHP on my computer. When I try to connect to MySql through Dreamweaver, I get the following error:
Your PHP Server does not have the MySql Module loaded or you can't use the MySql_(p)connect functions. I did everything it said to do with the .ini file and I think my libmysql.dll file is in the right place...but not sure. PHP works with Dreamweaver when previewing in the browser, but I cannot get the MySQL connection working.
In another attempt, I converted the MySQL tables to .csv through Access and uploaded them to a live website with a database (I created the database tables first) that I set up to test. It has PHPMyAdmin and I can upload one table correctly - the one with only one field. All of the other tables error out with "Invalid Field Count in CSV Line 1"
Can anyone help with either...or both?
A newbie PHP/MySQL chick
12-26-2006, 02:05 AM
first off , create a page with just this in it..
view the page and scroll down to see if MySQL module is loaded and what version.
If you see no reference to MySQL, check that it is running ... ctl-alt-del should show MySQL in the process list, if not what version did you install ?
Your second problem is best solved by installing phpMyAdmin on your local server (since it will export in a valid format) .. but that will not work until you get MySQL working.
12-26-2006, 12:41 PM
MySQL is running and I can get into it to modify tables. However, I do get this message at the bottome of the php-info page you had me create:
PHP Warning: PHP Startup: Unable to load dynamic library './php_mbstring.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library './php_msql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library './php_mysql.dll' - The specified module could not be found. in Unknown on line 0
I am not very sure as to why this could be a problem. That is to say:
1- php_mbstring.dll and php_mysql.dll files are damaged, or
2- you do not have these modules installed.
In either case, here is a good tutorial on how to install php extensions and modules on windows.
12-26-2006, 01:32 PM
Thanks! I went back through the .ini file and set the path for the extensions folder. That is what was missing. When I now run the php-info page I no longer am missing the module.
However, now when I try to connect I get the error message: MySQL Error #1045 Access denied for user root@localhost (using password: yes)
12-26-2006, 01:33 PM
Thanks for the tutorial - I solved the extensions problem.
Does anyone have an easy solution to install PHPMyAdmin? Seems pretty technical to me and I am a beginner!
It is very easy to install phpMyAdmin. Here is a simple procedure to do so.
1-download the latest release from http://www.phpmyadmin.net/home_page/index.php
2- uncompress the package in your root directory (the one that you use for your website) and call it phpmyadmin
3- locate the file config.inc.php within phpmyadmin. If you cannot find it, go into libraries and copy config.default.php and paste it into phpmyadmin. You should now rename config.default.php to config.inc.php
4- locate this line ( $cfg['Servers'][$i]['password'] ) should be around line 73
5- add a password that you used for mysql if you have created any. Otherwise leave it blank.
That should do it. Now go to http://localhost/phpmyadmin in order to test your installation.
By the way. You can install WAMP (http://www.wampserver.com/en/)which comes with PHP5, MYSQL5, PHPMyAdmin, SQLite, SQLiteManager etc.
The good thing about WAMP (http://www.wampserver.com/en/)is that you can also install PHP4 and you can easily switch between the two any time you wish.
12-26-2006, 06:31 PM
Personally I prefer XAMPP (http://www.apachefriends.org/en/xampp.html). Its similar to WAMP but I think it has more features.
12-28-2006, 01:33 AM
Just restarted MySQL and now it is working great with PHP and Dreamweaver!
Thanks for all the help! I will install PHPMyAdmin soon too. Has anyone ever heard of Xoops? Any comments about it?