UltraBeast
Programmer
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 (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~