Good day/night/whatever fellow techies, I've come to a small problem managing mysql on CentOS 4.7 box[1]. When I have done things on mysql on my desktop systems it was always just for personal use so I would be lazy and put everything under the "test" db so I didn't have to deal with all that security. But I find that I need to put some db's on the "production" box and could use a little assistance. I can manage with the bulk of the work but since mysql is all pre-configured on RH based systems I don't know where to find the root password or any other tidbits needed to get started. Access to the grant and other admin db's and tables is all I believe I need. Looking through the docs on centos.org didn't reveal anything to me (or I just missed it). So the end result of this message is simply can someone point me to the howto use mysql on CentOS/RHEL info. I just need to be able to start adding db's and such. Once there I'm good to go. Thank you in advance, Joe [1] I know, I should upgrade but, as I mentioned, I'm a real lazy guy. -- Using Linux since 11/1991 | http://www.linux.org Linux user #29402 | http://counter.li.org/ CentOS Linux | http://www.centos.org
On Sat, Sep 20, 2008 at 09:40:52PM -0400, Joe Klemmer wrote:> So the end result of this message is simply can someone point me to the > howto use mysql on CentOS/RHEL info. I just need to be able to start > adding db's and such. Once there I'm good to go. > > Thank you in advance, > Joe > > > [1] I know, I should upgrade but, as I mentioned, I'm a real lazy guy.Using a tool like phpMyAdmin might be perfect for you (even if you're not lazy). It's in EPEL, so just add the repo and yum install phpMyAdmin. Ray
Joe Klemmer wrote:> Good day/night/whatever fellow techies, > > I've come to a small problem managing mysql on CentOS 4.7 box[1]. When > I have done things on mysql on my desktop systems it was always just for > personal use so I would be lazy and put everything under the "test" db > so I didn't have to deal with all that security. But I find that I need > to put some db's on the "production" box and could use a little > assistance. > > I can manage with the bulk of the work but since mysql is all > pre-configured on RH based systems I don't know where to find the root > password or any other tidbits needed to get started. Access to the > grant and other admin db's and tables is all I believe I need. Looking > through the docs on centos.org didn't reveal anything to me (or I just > missed it). > > So the end result of this message is simply can someone point me to the > howto use mysql on CentOS/RHEL info. I just need to be able to start > adding db's and such. Once there I'm good to go. > > Thank you in advance, > Joe > > > [1] I know, I should upgrade but, as I mentioned, I'm a real lazy guy. >I don't know nuttin' about mysql but there's something about the root password here: http://kbase.redhat.com/faq/FAQ_39_4177.shtm
Hello, On Sat, Sep 20, 2008 at 21:40, Joe Klemmer <klemmerj at webtrek.com> wrote:> I don't know where to find the root > password or any other tidbits needed to get started.AFAIK, the MySQL server included on CentOS is configured to allow access to user "root" from either localhost or the same hostname where the server is running, and without a password. If you have a shell on the machine where the MySQL server is running, you should be able to connect to it with this command: $ mysql -u root -h localhost Please remember to set a password for the MySQL root user. To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h `hostname` password 'new-password' Obviously using a real password where it says 'new-password' above.> [...] on CentOS 4.7 box[1]. [...] > [1] I know, I should upgrade but, as I mentioned, I'm a real lazy guy.Well, you should upgrade only if you want to or if you need the new features of the new versions of applications included in 5. CentOS 4.7 is updated and supported, and as long as you regularly update it with yum you will get all the security updates until February 2012. See here: http://www.centos.org/modules/smartfaq/faq.php?faqid=42 HTH, Filipe
on 9-20-2008 6:40 PM Joe Klemmer spake the following:> Good day/night/whatever fellow techies, > > I've come to a small problem managing mysql on CentOS 4.7 box[1]. When > I have done things on mysql on my desktop systems it was always just for > personal use so I would be lazy and put everything under the "test" db > so I didn't have to deal with all that security. But I find that I need > to put some db's on the "production" box and could use a little > assistance. > > I can manage with the bulk of the work but since mysql is all > pre-configured on RH based systems I don't know where to find the root > password or any other tidbits needed to get started. Access to the > grant and other admin db's and tables is all I believe I need. Looking > through the docs on centos.org didn't reveal anything to me (or I just > missed it). >I do believe that a default install of Mysql leaves no root password, which you *should* add as soon as you start the service.> So the end result of this message is simply can someone point me to the > howto use mysql on CentOS/RHEL info. I just need to be able to start > adding db's and such. Once there I'm good to go. > > Thank you in advance, > Joe > > > [1] I know, I should upgrade but, as I mentioned, I'm a real lazy guy. >4.7 just came out. So what are you lazy about upgrading? -- MailScanner is like deodorant... You hope everybody uses it, and you notice quickly if they don't!!!! -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 250 bytes Desc: OpenPGP digital signature URL: <http://lists.centos.org/pipermail/centos/attachments/20080922/2a89ad6a/attachment-0001.sig>
> I do believe that a default install of Mysql leaves no root > password, which you *should* add as soon as you start the service. > > So the end result of this message is simply can someone > point me to the > > howto use mysql on CentOS/RHEL info. I just need to be > able to start > > adding db's and such. Once there I'm good to go. > > > > Thank you in advance, > > JoeA standard install of centos and mysql will have 4 items you need to be concerned with. There will be 2 anonymous users databases and 2 roots... You should delete the 2 anaonymous immediately and add a password for the two roots. For the root shell> mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = 'paswrd1'; mysql> SET PASSWORD FOR 'root'@'host_name' = 'passwrd2'; While in mysql as root, delete from mysql.user where user=''; (this will get rid of anonymous users. Anonymous will allow people to access your mysql server without a password. Until you add passwords to root, you are also highly insecure. Im too busy trying to figure out sendmail right now...lol
Joe Klemmer wrote:> So the end result of this message is simply can someone point me to the > howto use mysql on CentOS/RHEL info. I just need to be able to start > adding db's and such. Once there I'm good to go.1. Install mysql # yum install mysql-server mysql 2. Start MySQL Service To start mysql server type the following command: # chkconfig mysqld on # /etc/init.d/mysqld start 3. Setup mysql root password Type the following command to setup a password for root user: # mysqladmin -u root password NEWPASSWORD Test mysql connectivity Type the following command to connect to MySQL server: $ mysql -u root -p 4. Install phpmyadmin and configure it. 5. You are good to go. Thanks, Josh.
The OQO has the VIA HDA controller and I can listen to music via the headphone jack (need to try out USB headphone and BT head phone still). I get system beeps from the system speaker, but no music. The Audio Configuration gnome module reports that the snd-hda-intel module is being used . The Default PCM device is teh STAC92xx Analog, and the also libs and utils are being used. Can I get sound out the system speaker? There was a discussion about sound problems on the eeePC 1000H a bit ago:> But at the moment I'm stuck on the audio card. The system seems to > detect it happily enough as Intel HDA, with a Realtek ALC269 chip, but > there's no sound. I'm sure I've hit a similar problem in the past with > the snd-hda-intel driver - I think it's a matter of figuring out the > right value for the "model=..." parameter. Has anyone else got this to > work?I don't see where this 'model=' is to 'play' with it as others in the 1000H thread talked about. Perhaps since at least I am getting sounds through the headset jack, that is not where my challenge is. Any pointers on this?