Hello all, I'm trying to set up my first local webserver and I have some questions to ask. I looked thru the forum already, altho I could find similar questions... but there were no replies. Couldn't find any info on the web either after extensive search! So hope you guys could give me some ideas. Actually, My problem is with using phpmyadmin.
I (using Windows XP SP2) installed the current versions of Apache (2.2.4) then PHP (5.2.0) then MySQL (5.0), then unzipped the entire contents of phpmyadmin to c:\Apache\htdocs\phpmyadmin , run index.php then I get the login screen. Okay, then I log in as 'root' and expect everything to be running fine but I keep getting these problems:
1/ Can only Create New Database, but cannot Drop Database. When I select a database and then click on 'drop', I just get : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ' at line 1
2/ Cannot create any tables! When I try to create new table, just say give the table name 'abc' and number of fields '5', or whatever, no matter what I just get
The field count is empty!
3/ Cannot create new user. Screen just refreshes without taking any action.
4/ Cannot even Log Out. Same with many things else that I click on, the screen just refreshes and shows me the same screen with no actions being taken.
5/ In short, I can do pretty much nothing to my database using phpmyadmin.
Besides these, I have this message at the bottom of my phpmyadmin screen:
The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
6/ Uh oh... is that message a big problem then? Now that PHP 5.2.0 is already installed (before I installed mySQL) how do I add/remove components ? When I installed, I didn't choose all the components (ActiveScript, EXIF, etc.) except for MySQL and MySQLi.
Hope anyone could help me with this. muchos gracias~
I have cut and pasted the good bits in case the post at the other site gets dropped.
To find out what the error is set
display_errors = On
in the php.ini.
In my case the problem were the sessions. They could not be saved because the session save path did not exist.
Go to the php.ini and search for "session.save_path". Adjust the value and create the folder.
As far as the last two problems go there are several tutorials on how to enable extensions, but the one you want to enable is the Multi-byte character extension. You are using windows so you just need to download the PHP 5.2.* installer file and run it. Do a custom install (if it asks) and pick the multi-byte extension from the list of extensions. Installing all the extensions caused my PHP to not work at all and installing just the multi-byte extension did not work either. I also had to install the mysql and mysqli extensions.
One thing I forgot to mention. I had to reboot the entire server for some reason after doing the PHP re-install to add the extensions. I tried restarting IIS but it did nothing. You are using apache so Im not sure if you will need to reboot or not, but if it does not work after the re-install try rebooting.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Latest: 
Visitation: 
