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
It’s true that your website is very good, and it’s all well organized here.
We could’ve done with that insight early on.
Very interesting information, thanks.
Excellent and very thoughtful post! I rellay appreciate the time and effort you put in every single one of your posts, and finally decided to drop a comment on one of them! If you got some extra time on your hands and looking to improve your search engine rankings in the new Google Caffeine search results take a look at the Google Caffeine eBook Anyways, good luck on your blog, and feel free to check out : Thanks so much! All the best,Dino Vedo
OMG! Thank you. This was just the info I needed. The 2nd method was so easy. I would suggest one edit to your instructions for Step 4. I had a devil of a time locating the “Optimize Table” link. Had to click Details link below the table, and found the Optimize Table link at the bottom of the Space usage info.Whew!
Good to see real expertise on dsipaly. Your contribution is most welcome.
This is a valid and much appreciated post but the steps overlook the syntax error for creating the waiting_list table. Thank you Roka for submitting the correct syntax. For those who do not speak Spanish, please refer to Roka’s post for the correct syntax for creating the jos_vm_waiting_list table. Or you can just copy the following and paste it into the sql tab section within PHPmyadmin. It’s all the same ## #### Table structure for table `jos_vm_waiting_list`## CREATE TABLE `jos_vm_waiting_list` ( `waiting_list_id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `notify_email` varchar(150) NOT NULL DEFAULT , `notified` enum( 0 ,’1 ) DEFAULT NULL, `notify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`waiting_list_id`), KEY `product_id` (`product_id`), KEY `notify_email` (`notify_email`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;#### Dumping data for table `jos_vm_waiting_list`##