• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Search | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

setting up password on mysql

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
duster
Just Arrived
Just Arrived


Joined: 06 May 2005
Posts: 0


Offline

PostPosted: Tue May 26, 2009 10:11 am    Post subject: setting up password on mysql Reply with quote

im attempting to set the password for the first time in mysql and im recieving the following message .. "to few arguements to change password" my syntax is below.. any ideas?

mysqladmin -u root password 'my_password'
Back to top
View user's profile Send private message
heba
Just Arrived
Just Arrived


Joined: 09 Jan 2006
Posts: 4
Location: Cremona (Italy)

Offline

PostPosted: Tue May 26, 2009 12:10 pm    Post subject: Reply with quote

usually when you install mysql for the first time ask you to set up the password, this is automatically, if you haven't this message or you have not set up the password when the system have ask you, this is not set up again like first password, but you can try to give the command with:

Stop the process

Code:
mysqld stop


Run again the process

Code:
mysql --skip-grant tables &


Enter like root in mysql

Code:
 mysql -u root mysql


Set up again the password

Code:
 UPDATE user SET password=PASSWORD("new pass") WHERE User="root";
FLUSH PRIVILEGES;
exit;


Restart mysql

Code:
mysql restart



try this, but it don't run, try also to reinstall completely mysql, if in any way you don't solve, write here again with every step you done and various error, please
Back to top
View user's profile Send private message
duster
Just Arrived
Just Arrived


Joined: 06 May 2005
Posts: 0


Offline

PostPosted: Tue May 26, 2009 3:44 pm    Post subject: Reply with quote

That work thanks alot. i tried to reinstall it but it keep the old password so i had the same problem but ive now been able to reset...
Back to top
View user's profile Send private message
heba
Just Arrived
Just Arrived


Joined: 09 Jan 2006
Posts: 4
Location: Cremona (Italy)

Offline

PostPosted: Wed May 27, 2009 12:11 pm    Post subject: Reply with quote

no problem for the reply... Surprised

sometimes the old setting remain registered in the hard disk, have you try to purge mysql setting and to erase completly mysql before reinstall?
Back to top
View user's profile Send private message
duster
Just Arrived
Just Arrived


Joined: 06 May 2005
Posts: 0


Offline

PostPosted: Wed May 27, 2009 12:24 pm    Post subject: Reply with quote

dont know how to purge... im not an mysql admin
Back to top
View user's profile Send private message
heba
Just Arrived
Just Arrived


Joined: 09 Jan 2006
Posts: 4
Location: Cremona (Italy)

Offline

PostPosted: Wed May 27, 2009 1:06 pm    Post subject: Reply with quote

are in windows, linux or macos, please?
Back to top
View user's profile Send private message
duster
Just Arrived
Just Arrived


Joined: 06 May 2005
Posts: 0


Offline

PostPosted: Wed May 27, 2009 2:56 pm    Post subject: Reply with quote

heba wrote:
are in windows, linux or macos, please?



linux
Back to top
View user's profile Send private message
heba
Just Arrived
Just Arrived


Joined: 09 Jan 2006
Posts: 4
Location: Cremona (Italy)

Offline

PostPosted: Wed May 27, 2009 3:10 pm    Post subject: Reply with quote

in this case depend of your distro.

For Ubunut/Kubuntu/Debian and derivates:

Code:
 # apt-get purge mysql


if you have any other distribution you can go in manage packages

find mysql

and when you give the command to delete the file you see a pop up window and after select remove all packages with all configuration files.

and the system erase completely all packages.
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Community Area

Log in | Register