Dreamweaver PHP Tutorial Comes To A Hault.

[Devious Designs]

* Local host, PowerMac G5.
* PHP 4.3.11 for Apache 1.3
* Mysql 4.0.26


To create the sample MySQL database:
1. Copy the SQL script file, insert.sql, to an appropriate folder on the
computer that has MySQL installed.
2. If you installed Dreamweaver to its default location, the path to the
script file is as follows:
? C:\Program Files\Macromedia\Dreamweaver MX 2004\Samples\Database\insert.sql
(Windows)
? /Applications/Macromedia Dreamweaver MX 2004/Samples/Database/insert.sql
(Macintosh)
3. If the computer running MySQL is a Windows computer, copy the insert.sql
script to MySql\Bin. If the computer running MySQL is a Macintosh, copy the
insert.sql script to your Documents folder in your home folder.
4. On the computer that has MySQL installed, open a command prompt window
(Windows) or a Terminal window (Macintosh).
? In Windows, you can open the command prompt by selecting Start > Programs >
Command Prompt or Start > Programs > Accessories > Command Prompt.
? On the Macintosh, you can open a Terminal window by going to the
Applications folder, opening the Utilities folder, and double-clicking Terminal.
5. (Windows only) Change to the mysql\bin directory by entering the following
commands at the command prompt:
6. cd \
7. cd mysql\bin
8. Note: On the Macintosh, you should be able to run mysql from any directory;
it should have been added to your path during installation of MySQL. If the
following step doesn't work on the Macintosh, though, try typing
/usr/local/bin/mysql instead of mysql.
9. Start the MySQL client by entering the following command:
10. mysql -uUser -pPassword
11. For example, if your MySQL user name (also known as an account name) and
password are Tara and Telly3, then enter the following command:
12. mysql -uTara -pTelly3
13. If you don't have a password, omit the -p argument as follows:
14. mysql -uTara
15. If you didn't define a user name while configuring your MySQL
installation, enter root as the user name, as follows:
16. mysql -uroot
17. The MySQL client's command prompt appears, as follows:
18. mysql>
19. Create a new database by entering the following command at the MySQL
prompt:
20. mysql>CREATE DATABASE TrioMotors;




Last login: Mon Mar 27 23:05:38 on ttyp1
Welcome to Darwin!
mac:~ albert$ mysql -uMonaco
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.1.18-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE TrioMotors;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'triomotors'
mysql>

Please help. :)

[Michael Fesser]

..oO(Devious Designs)

> mac:~ albert$ mysql -uMonaco
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 13 to server version: 4.1.18-standard
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> CREATE DATABASE TrioMotors;
> ERROR 1044 (42000): Access denied for user ''@'localhost' to database
>'triomotors'
> mysql>
>
> Please help. :)

You have to login as 'root' to create a new database and grant access
privileges to a particular user.

Micha