myqsl dummy needs help

[Gene Heskett]

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 at 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 at 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 at coyote /]# mysql -u root -p
>>> Enter password:
>>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>>> password: YES) [root at coyote /]# mysql -u root -p
>>> Enter password:
>>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>>> password: NO) [root at 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