Skipjackrick Posted September 19, 2009 Share Posted September 19, 2009 So, I installed MySQL version 5.1, Apache 2.2, and php 5 on Windows XP. I am trying to use phpmyadmin and it doesn't work. I dropped the phpmyadmin files in my root directory and opened up the phpmyadmin/index.php file and I get this error. phpMyAdmin - Error Cannot load mysql extension. Please check your PHP configuration. Here are a few questions. How do I know my MySQL is working properly? Is there a way to test it? I tested php and it works fine using a test program. Next, I need to create a database and define users, and passwords, tables etc in MySQL but I have no idea how to do this using mysql. I have always done it using phpmyadmin through the web. I am trying to install this locally on my computer so I can test things faster. What do I edit in my PHP configuration? Can anybody help me out? Quote Link to comment https://forums.phpfreaks.com/topic/174774-solved-mysql-starts-now-what/ Share on other sites More sharing options...
trq Posted September 19, 2009 Share Posted September 19, 2009 How do I know my MySQL is working properly? Connect to it via its command line interface. Open cme.exe and type... mysql Next, I need to create a database and define users, and passwords, tables etc in MySQL but I have no idea how to do this using mysql. I have always done it using phpmyadmin through the web. This can all be done via the same command line interface, most people prefer however to have some point and click option. Quote Link to comment https://forums.phpfreaks.com/topic/174774-solved-mysql-starts-now-what/#findComment-921079 Share on other sites More sharing options...
Skipjackrick Posted September 19, 2009 Author Share Posted September 19, 2009 This can all be done via the same command line interface, most people prefer however to have some point and click option. Yeah, that's what I need. I've been trying to install phpmyadmin. I believe mysql is working properly because I can pull it up in a command prompt. what would be the command to create a db? Same as Php? mysql_create_db("sharkathon") or die(mysql_error()); Nope apparently not. Quote Link to comment https://forums.phpfreaks.com/topic/174774-solved-mysql-starts-now-what/#findComment-921082 Share on other sites More sharing options...
trq Posted September 19, 2009 Share Posted September 19, 2009 Same as Php? mysql_create_db("sharkathon") or die(mysql_error()); Nope apparently not. mysql_create_db is a php function not a command of any kind. The mysql command line interfaces expects sql statements and simple commands. It shows you a help message when you first login. CREATE DATABASE foo; Quote Link to comment https://forums.phpfreaks.com/topic/174774-solved-mysql-starts-now-what/#findComment-921083 Share on other sites More sharing options...
Skipjackrick Posted September 19, 2009 Author Share Posted September 19, 2009 CREATE DATABASE foo; Ah, thanks....working now. Sometimes its so easy its stupid. Quote Link to comment https://forums.phpfreaks.com/topic/174774-solved-mysql-starts-now-what/#findComment-921085 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.