grouping and limiting results and rand()

2013-09-23 Thread Jeremiah Jester
Hello, How would i go about selecting 5 random cars that are flagged as internet_special (value 1) for each dealer from a specific table? Ive tried sub selects with no luck. Here's a basic query that has my required conditional. Note that I get all unique dealers by doing a

mysql password

2001-12-18 Thread Jeremiah Jester
Im attempting to install mysql. The service started and everything seems to be going ok except for that I can't set the root password for the mysql server. To reset password i type: /usr/bin/mysqladmin -u root -p mypassword Then I get the following error: /usr/bin/mysqladmin: connect to

Reset MySQL Root password

2001-12-18 Thread Jeremiah Jester
Well it seems as though i may have mistyped my root password for mysql since nothing seems be working. Anybody no how to set a new root password or how to reset the old password in mysql? Already tried uninstalling the RPM from in hopes to redo the install but when i try it tells me the package