Hi All,
I'm new here, just starting to learn PHP and MySQL. I have a very
frustrating problem that I hope has a simple answer.
First of all, I'm not an inexperienced programmer, though I've mostly
worked in environments where there were system administrators I could call
on for set-up help. I'm experienced with Apache, Cold Fusion, Oracle, SQL
Server, Java, JSP, and others. I'm working on my own computer running
Windows XP.
I started with SAMS Teach Yourself PHP, MySQL and Apache, All in One, by
Julie Meloni. I installed MySQL 4.0.21, Apache 2.0.52 and PHP 5.0.2 from
the CD included with the book, following the book instructions. All were
generic installs and Apache is running fine, as is WinMySQLAdmin 1.4, which
shows MySQL to be running fine.
From the documentation, I see that the default user and password are both
'test'. There was nothing in the install process that referenced either
user or password where I could have inadvertently changed anything.
I am able to start the MySQL monitor by double clicking the file in my
directory or from the command line, using just:
C:\mysql\bin>mysql
or
C:\mysql\bin>mysql -u test
If I type either:
C:\mysql\bin>mysql -u test -p test
or
C:\mysql\bin>mysql -u test -p test -h localhost
I get a password prompt. If I enter 'test' I get an error message saying,
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' <using password: YES>
If I back up and start the monitor without using a password and I try to do
anything, such as create a database, 'CREATE DATABASE calendar;' I get this
error: ERROR 1044: Access denied for user: 'localhost' to database 'calendar'
I have spent hours looking at several other books, reading documentation,
and experimenting, etc and can't figure out how to get past this. It has me
dead in the water and so frustrated I could scream.
Any help would be greatly appreciated,
Linda
Any help would be appreciated
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
