Re: [cobalt-users] Set-up MySQL on RaQ 550

[Bruce Timberlake <bruce@xxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> I am in search of some info in regards to MySQL on a RaQ 550. I
> know it comes installed as a default.
>
> I have started the MySQL services. I can connect to MySQL by mysql
> in telnet I can see DB's and stats. It seems like everything is
> working ok. When I go to try and connect to it from a virtual site
> I simply can't. Is there something I need to do to MySQL to make it
> work with virtual sites and os Commerce or other programs?

1. Have you already created at least one MySQL username and password
   for 'os commerce' in the 'user' table of the 'mysql' database?
2. Have you created a separate database for 'os commerce'?
3. Have you granted access privileges for the 'os commerce' user
   to the 'os commerce' database in the 'db' table of the 'mysql'
   database?
4. Have you reloaded MySQL so changes to the grants table take effect?
5. If 1-4 are 'yes' can you manually connect to MySQL as the 'os
   commerce' user to the 'os commerce' database and manipulate it
   properly?
6. If 5 is 'yes' then the problem is with the script/etc for 'os
   commerce' (it's not configured to use the right database name,
   username, password, etc)
7. If 5 is 'no' go back to 1-4 and make sure they are done properly
   (especially check #4 - I _always_ forget to do that myself!)

- -- 
Bruce Timberlake

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+IPTDvLA2hUZ9kgwRAvtIAJ9M6ciHhkdFECA86i/YMDJTh7k+mACfZXwv
ifMQJsml++gNJVjY+PLhzCg=
=kIaj
-----END PGP SIGNATURE-----