#1  
Old 5th April 2006, 18:48
linuxisnew linuxisnew is offline
Junior Member
 
Join Date: Apr 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Mysql help

I have a web server setup with a database. The server was configured by a company who is unable to help me. They did not set a password on Mysql so I did. I have been down many trails to make the database work with a password and every time I get some part working I find another is broken. What I would like to do at this time is remove the password from mysql until I have more knowledge. Here is the statement I used to put the password on. mysqladmin -u root password yourrootsqlpassword . Yes I did replace yourrootsqlpassword with a real password. I hope some one can help, Thanks
Reply With Quote
Sponsored Links
  #2  
Old 5th April 2006, 21:40
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

You can run
Code:
mysqladmin -u root password ''
or use MySQL's GRANT command ( http://dev.mysql.com/doc/refman/5.0/en/grant.html ) or change the password directly in the mysql database (table users) with phpMyAdmin.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 11th April 2006, 00:37
linuxisnew linuxisnew is offline
Junior Member
 
Join Date: Apr 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default Thanks

I was finally able to get the password changed in all the locations I needed to and now know how to set or change the password for Mysql and phpMyAdmin. I will keep this information should I lock myself out again.

Thank You,
April
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR: The PHP binary coming with ISPConfig does not work properly on your system! qvindesland Installation/Configuration 22 21st May 2007 16:05
postfix - MySQL connection problem epo Installation/Configuration 7 4th August 2006 20:49
MySQL installation roblem [/me sad] Nejko Installation/Configuration 16 11th January 2006 13:28
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41


All times are GMT +2. The time now is 17:59.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.