[CentOS] mysql problems

Wed May 17 21:39:24 UTC 2006
William Warren <hescominsoon at emmanuelcomputerconsulting.com>

unfortunately plesk requires root to install so it takes over the mysql 
server..:(

John Newbigin wrote:
> So plesk has some bugs... why re-install mysql?  If you don't know the 
> password you can just start it up with --skip-grant-tables and set a new 
> one.
> 
> I don't know why but it seems common for mysql apps to screw up the root 
> account (mediawiki did this recently).  The solution? don't put your 
> root password into an untrusted application.  Create a new account using 
> the mysql command line client and then give those details to your 
> application.
> 
> John.
> 
> William Warren wrote:
> 
>> I installed plesk(first mistake at least here..<G>) and it got in my 
>> way in some area more than it helped.  The first thing it did was deny 
>> root access to mysqld and i could not find the username and password 
>> for adding another database.  I removed plesk and mysql.  when i used 
>> yum to reinstall mysql i was then told root @ localhost was denied.  I 
>> removed mysql again and nuked all of the mysql files i could find that 
>> were left behind.  Now when i reinstall it won't even start.  Any ideas?
>>
> 
> 

-- 
My "Foundation" verse:
Isa 54:17  No weapon that is formed against thee shall prosper; and 
every tongue that shall rise against thee in judgment thou shalt 
condemn. This is the heritage of the servants of the LORD, and their 
righteousness is of me, saith the LORD.

-- carpe ductum -- "Grab the tape"
CDTT (Certified Duct Tape Technician)

Linux user #322099
Machines:
206822
256638
276825
http://counter.li.org/