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.
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
Hi,
Just wondering if anyone else was trying to get Centos 5.2 onto an EeePC 1000H?
My EeePC came with XP, and I planned to put Centos on it in a dual-boot config. I've been struggling with this for a few evenings now, with some success (the wired ethernet is atl1e (gigabit rather than 10/100) - not supported in the latest Centos 5.2 kernel, but I managed to build in support using this:
http://rpm.pbone.net/index.php3?stat=26&dist=46&size=73086&name=...
(it's a Suse RPM, so takes a bit of persuading to install on Centos: I'll post details of the method I used if anyone wishes.)
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?
Thanks in advance for any comments.
On Sun, 21 Sep 2008 16:05:44 +0100 Peter Duffy peter@mhoram.demon.co.uk wrote:
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=..." parameer. Has anyone else got this to work?
That "model=" issue took me about three days to figure out when I set up my wife's new laptop (not an eee-pc) last Christmas. There is a fairly comprehensive list of valid model= entries somewhere on the Internet that I found at that time, and by going through them one at a time I finally found one that worked.
Not that it matters, but "model=toshiba" is the one that eventually worked. Which is interesting because it's not a toshiba laptop.
The lesson here is, don't eliminate any entries as not relevant because your machine isn't that model.
Frank Cox a écrit :
Not that it matters, but "model=toshiba" is the one that eventually worked. Which is interesting because it's not a toshiba laptop.
The lesson here is, don't eliminate any entries as not relevant because your machine isn't that model.
Same here. My wife has an ASUS laptop with an ICH sound card. 'model=asus' didn't work, but 'model=3stack' eventually worked. Took me a week to find that out.
Niki
In my efforts to get the sound hardware working, I eventually decided to try the latest vanilla kernel (2.6.27-rc6). I had a bit of a battle to get it to work (it kept detecting the SATA disk as standard IDE, so blocking the SATA drivers, and making the system run like a dog: I finally fixed this by rebuilding the kernel with the IDE driver defined as a module. However, the sound hardware now seems to work (with "model=basic" - apparently this is the recommended setting for the ALC269.)
Next challenge is to get the wireless network working!
On Sun, 2008-09-21 at 20:54 +0200, Niki Kovacs wrote:
Frank Cox a écrit :
Not that it matters, but "model=toshiba" is the one that eventually worked. Which is interesting because it's not a toshiba laptop.
The lesson here is, don't eliminate any entries as not relevant because your machine isn't that model.
Same here. My wife has an ASUS laptop with an ICH sound card. 'model=asus' didn't work, but 'model=3stack' eventually worked. Took me a week to find that out.
Niki _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
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?
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@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?
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
A 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
shell> mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = 'paswrd1'; mysql> SET PASSWORD FOR mysql> 'root'@'host_name' = 'passwrd2';
Do not know why the mail messed those lines up
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.
-
Bob Hoffman -
Chris Boyd -
Filipe Brandenburger -
Frank Cox -
Joe Klemmer -
Josh Donovan -
Niki Kovacs -
Peter Duffy -
Ray Van Dolson -
Robert -
Robert Moskowitz -
RobertH -
Scott Silva