On Monday 16 February 2009, Robert L Cochran wrote:
The documentation on the MySQL website that I pointed to, and that
detailed in Paul DuBois' book, absolutely works for all Fedora
implementations of MySQL. The Fedora distro packagers do not do anything
"Fedora different" from a standard MySQL installation.
I know from having studied the spec files in Fedora source packages for
mysql-server and from having to clean up my own messes now and then that
this is so.
What is important...is to very carefully read and research the
documentation provided first, before ever doing anything.
Bob
Craig White wrote:
> On Mon, 2009-02-16 at 14:06 -0500, Gene Heskett wrote:
>> On Monday 16 February 2009, Craig White wrote:
>>> ----
>>> I think original setup for mysql is for root user via local socket and
>>> not via localhost so there actually isn't an account for root@localhost
>>> thus attempting to connect via tcp/ip as root is doomed to fail out of
>>> the box.
>>>
>>> Craig
>>
>> With all due respect Craig, what the hell use is it then when ALL the
>> documentation is wrong?
>>
>> Now, I just had the bright idea of looking at the mysqld.log after
>> ripping it all out and putting even more of it back in, and see this:
>>
>> [root@coyote etc]# cat /var/log/mysqld.log
>> 090216 13:30:36 mysqld ended
>>
>> 090216 13:30:45 mysqld started
>> /usr/libexec/mysqld: Can't create/write to file '/tmp/ibnoIZas'
(Errcode:
>> 13) 090216 13:30:45 InnoDB: Error: unable to create temporary file;
>> errno: 13 090216 13:30:45 [Note] /usr/libexec/mysqld: ready for
>> connections. Version: '5.0.45' socket:
'/var/lib/mysql/mysql.sock'
>> port: 3306 Source distribution
>>
>> So obviously /tmp doesn't have the right perms. Or at least I assume
>> (there is that word again) that an error 13 is permissions related.
>> Selinux is in targeted mode, enabled, and it isn't fussing.
>>
>> /tmp itself is drwxr-xr-x amanda disk system_u:object_r:tmp_t:s0
>> tmp but nearly everything in it is root:root except the amanda and
>> amanda-debug directories. So I just changed tmp to drwxrwxrwx But that
>> also didn't change anything. Or did it, now the log shows this when I
>> restart mysqld:
>>
>> 090216 13:51:44 mysqld started
>> InnoDB: The first specified data file ./ibdata1 did not exist:
>> InnoDB: a new database to be created!
>> 090216 13:51:44 InnoDB: Setting file ./ibdata1 size to 10 MB
>> InnoDB: Database physically writes the file full: wait...
>> 090216 13:51:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be
>> created InnoDB: Setting log file ./ib_logfile0 size to 5 MB
>> InnoDB: Database physically writes the file full: wait...
>> 090216 13:51:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be
>> created InnoDB: Setting log file ./ib_logfile1 size to 5 MB
>> InnoDB: Database physically writes the file full: wait...
>> InnoDB: Doublewrite buffer not found: creating new
>> InnoDB: Doublewrite buffer created
>> InnoDB: Creating foreign key constraint system tables
>> InnoDB: Foreign key constraint system tables created
>> 090216 13:51:46 InnoDB: Started; log sequence number 0 0
>> 090216 13:51:46 [Note] /usr/libexec/mysqld: ready for connections.
>> Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port:
3306
>> Source distribution
>>
>> Which says one problem seems to be sorted, at the expense of a huge
>> security hole in /tmp as anyone can do anything there now.
>>
>> Ok, so now try a login again:
>> [root@coyote /]# mysql -u root -p
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost'
(using
>> password: YES) [root@coyote /]# mysql -u root -p
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost'
(using
>> password: NO) [root@coyote /]#
>>
>> Seems like this is where I started, isn't it?
>>
>> Now that the tmp perms is sorted, I suppose I need to go back and do all
>> that other stuff again...
>>
>> Which I just did, and didn't change a thing. WTF?
>> Thanks Craig
>
> ----
> after initial installation but before you actually ever start mysqld
> service...
>
> mysqladmin - u root password 'new-password'
>
> *might* work after the mysqld service has already been started but if
> you look at the script involved in /etc/init.d/mysqld, much will happen
> the first time you start it.
>
> You can always stop mysqld service, empty contents of /var/lib/mysql and
> start the service if you don't care about any of the setup.
>
> As for the documentation...it's not wrong but the documentation doesn't
> account for what the various distributions will do with their
> initialization scripts.
>
> If it's all too much for you, install webmin and use that to
> create/maintain user accounts in mysql.
>
> Craig
webmin not available according to yum.
Ok, so I rip it out again, only this time I run a script that searches the
locate database for mysql and deletes all the leftovers before I reinstall.
Would that help? Something is obviously completely fubar.
--
Cheers, Gene
"There are four boxes to be used in defense of liberty:
soap, ballot, jury, and ammo. Please use in that order."
-Ed Howdershelt (Author)
It's not enough to be Hungarian; you must have talent too.
-- Alexander Korda