You know, I suppose I could simply install the tarball, I've successfully installed mysql in the past that way. However, I thought I'd use yum, install the redhat/CentOS way, and I am amazed how hard it is to get this thing working. I admit to not having become all that familiar with mysql. Anyway, when I run # mysql_install_db --user=mysql I get a bunch of errors: 070321 11:50:43 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13) So I find out where the file is, and cd /var/lib/mysql and to confirm I do a ls ./mysql/help_relation.frm I run # mysql_install_db --user=mysql Same error. I'll be glad for some help, but a secondary point I'd like to make is, what's the point in having packages if a lot of this stuff isn't already taken care of? Obviously the yum package manager puts the mysql distro in different places than the mysql tarball does by default. But shouldn't the package's config files take all that into account? Why is this so hard? === Al
On Wed, 2007-03-21 at 13:00 -0700, Al Sparks wrote:> You know, I suppose I could simply install the tarball, I've > successfully installed mysql in the past that way. However, I thought > I'd use yum, install the redhat/CentOS way, and I am amazed how hard > it is to get this thing working. I admit to not having become all > that familiar with mysql. > > Anyway, when I run > # mysql_install_db --user=mysql > > I get a bunch of errors: > > 070321 11:50:43 [ERROR] /usr/libexec/mysqld: Can't find file: > './mysql/help_topic.frm' (errno: 13) > > So I find out where the file is, and > cd /var/lib/mysql > and to confirm I do a > ls ./mysql/help_relation.frm > > I run > # mysql_install_db --user=mysql > > Same error. I'll be glad for some help, but a secondary point I'd > like to make is, what's the point in having packages if a lot of this > stuff isn't already taken care of? Obviously the yum package manager > puts the mysql distro in different places than the mysql tarball does > by default. But shouldn't the package's config files take all that > into account? > > Why is this so hard?You don't have to initialize mysql db : it will be done automagically when you'll start the mysqld service for the first time (service mysqld start) ... Have a look in the mysqld init script (that rpm/yum provides you so gently) , especially in the start() function ... -- Fabian Arrotin <fabian.arrotin at arrfab.net> Solution ? echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc
On 3/21/07, Al Sparks <data345 at yahoo.com> wrote:> You know, I suppose I could simply install the tarball, I've > successfully installed mysql in the past that way. However, I thought > I'd use yum, install the redhat/CentOS way, and I am amazed how hard > it is to get this thing working. I admit to not having become all > that familiar with mysql. >You're going about this the hard way really. 'yum install mysql-server' and then 'service mysqld start' the database is initialized automatically, and everything is set up for you with db files in /var/lib/mysql/>From there it's a simple matter of setting the mysql root password,and you're off and running. -- During times of universal deceit, telling the truth becomes a revolutionary act. George Orwell
> You don't have to initialize mysql db : it will be done > automagically when you'll start the mysqld service for the first > time (service mysqld start) ... > Have a look in the mysqld init script (that rpm/yum provides you > so gently) , especially in the start() function ...Well, I guess that's a DOH on my part. Of course they'd provide and use the init scripts in /etc/init.d. This may have something to do with all the previous things I've attempted after the install, but when I actually invoke the script it says the startup fails. However, the mysql.log shows that the database successfully starts, and I'm able to get a mysql prompt. Thanks for your help. === Al
Seemingly Similar Threads
- Driving me nuts!!! - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- MySQL server install with datadir != /var/lib/mysql
- MySQL on CentOS 6 broken? No 'mysql' database?
- Subsetting within xyplot()
- avoiding expression evaluation when calling a function