Computing.Net > Forums > Web Development > MySQL Problem

MySQL Problem

Reply to Message Icon

Original Message
Name: tImmaY
Date: July 4, 2004 at 01:34:51 Pacific
Subject: MySQL Problem
OS: Windows xp pro
CPU/Ram: AMD Athlon XP 2400+/512 m
Comment:

hey, i want to learn php and i want to be able to test code that i do without having to upload it to a server, esp. since i'm having problems finding a free host that'll let me do what i want to do. so i installed the apache server 2.0, installed MySQL 4.0.20d, and php 4.3.7<period> so the apace server is working, i can connect to it, so can the computers on my network and thats all fine and dandy. but i'm trying to set up the mysql and i'm having problems. when i try to do the test c:\mysql\bin\mysql show according to the mysql site its should have databases|mysql / test but i only have the test. it wont allow me to do the other 2 tests either, for the c:\mysql\bin\mysqlshow mysql it says access denied for user '@localhost' to database 'mysql' but c:\mysql\bin\mysqlshow test works. the other test command they have for u to do doesn't work either. anyone know whats wrong? thanks in advance.. ::tim


Report Offensive Message For Removal


Response Number 1
Name: tImmaY
Date: July 4, 2004 at 03:02:11 Pacific
Subject: MySQL Problem
Reply: (edit)

hmm.. odd.. w/o specifying a user it says that access is denied, but when i add the "-u root" after the path then it gives me output. however, its still not what the mysql manual says it should be. heres a pic of what it tells me:
http://img16.photobucket.com/albums/v48/anarchy85/mysqlproblem.jpg


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: MySQL Problem

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software




How often do you use Computing.Net?

Every Day
Once a Week
Once a Month
This Is My First Time!


View Results

Poll Finishes In 4 Days.
Discuss in The Lounge