MySQL new install

Installed MySQL in a OES2 server this week, install went fine. YaST install was fast and seamless. Used the Linux client to setup the users and the databases, creating the databases and users was straight forward once the syntax was correct, thanks to google made finding the syntax fairly painless.
Once created this is where problem started, getting the users access to the databases for a workstation. Mostly this issue was created by the permissions and syntax. Finally installed phpMyAdmin on the system, This took a little work on the OES2 server, download the phpMyAdmin, started install the dependencies where quick to resolve, with YaST, except pwgen. Finally found the rpm for pwgen for SLES10 x86_64 and installed it.
Finished phpMyAdmin install and logged in, deleted the users and the databases I had created, recreated them and added the proper permissions, then things started working the way the should.

Useful sites:
MySQL Tutorial
W3 School MySQL Tutorial
Database Journel MySQL Permissions