06-13-2010
Error when trying to set Admin password in MySQL
I'm trying to set an admin password for MySQL using the following command:
$ /usr/local/mysql/bin/mysqladmin -u root -p new_password
But, I get the following error message?
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
What should I do to set the admin password?
Thanks.
8 More Discussions You Might Find Interesting
1. Cybersecurity
Hiya all,
Newbie here - hope you can help
Trying to set up a login authorization on my website.
Reading away - it says works well with MySql database. Apache book goes onto to explain how to install Mysql etc....
But How do I set up the login page tho?
Please assist
Cheers... (5 Replies)
Discussion started by: marty 600
5 Replies
2. Solaris
How do you reset a forgotten administrator password in unix on a Sun Sunblade 100?
:mad: (1 Reply)
Discussion started by: mehow
1 Replies
3. Solaris
I have one Sun Netra T2000 Server. The ALOM SC admin password of this server is not known. Could you anyone help and tell me how can i reset the SC admin account password??
Thanks in advance.. (2 Replies)
Discussion started by: sudhir_shet
2 Replies
4. UNIX and Linux Applications
hi, linux gurus...
i'm trying to write a script in ksh called ResetPass that allows a user to change mysql passwords. the script accepts user, password and host like this: ResetPass <user> <password> <host>. here's the code:
*****************************************************
mysql... (1 Reply)
Discussion started by: ankimo
1 Replies
5. Gentoo
i have gentoo and i dont know what is my password user admin(root)
how i can to rest my passord?
thanks. (2 Replies)
Discussion started by: turivnkl
2 Replies
6. Solaris
Dear all
I have two doubts please clarify my doubt with clear steps
1. As a admin i forget my password how could i know whats my password.
2. If someone change my password how could i rectify that
Please give me reply. with clear steps (0 Replies)
Discussion started by: suneelieg
0 Replies
7. Solaris
Dear All Users
I have two doubts please any one clarify my doubts
1. In solaris As a admin i've forget my password so how could i know whats my password
2. if someone change my password so how could i rectify my password.
Please can anyone solve my doubt with clear steps (2 Replies)
Discussion started by: suneelieg
2 Replies
8. Solaris
Can someone please help here on how to reset a T1 lom password? I have tried the JP13 an try to find lom.conf in scadm dir but lom.conf is not on the machine ,some help thanks (1 Reply)
Discussion started by: rafise
1 Replies
LEARN ABOUT REDHAT
mysqlaccess
MYSQLACCESS(1) General Commands Manual MYSQLACCESS(1)
NAME
mysqlaccess
- Create new users to mysql.
USAGE
mysqlaccess [host [user [db]]] OPTIONS
SYNOPSIS
mysqlaccess [-?|--help] [-v|--version] [-p|--password=#] [-h|--host=#] [-d|--db=#] [-U|--superuser=#] [-P|--spassword=#] [-H|--rhost=#]
[--old_server] [-b|--brief] [-t|--table] [--relnotes] [--plan] [--howto] [--debug=N] [--copy] [--preview] [--commit] [--rollback]
DESCRIPTION
-?|--help
display this helpscreen and exit
-v|--version
print information on the program `mysqlaccess'
-u|--user=#
username for logging in to the db
-p|--password=#
validate password for user
-h|--host=#
name or IP-number of the host
-d|--db=#
name of the database
-U|--superuser=#
connect as superuser
-P|--spassword=#
password for superuser
-H|--rhost=#
remote MySQL-server to connect to
--old_server
connect to old MySQL-server (before v3.21) which does not yet know how to handle full where clauses.
-b|--brief
single-line tabular report
-t|--table
report in table-format
--relnotes
print release-notes
--plan print suggestions/ideas for future releases
--howto
some examples of how to run `mysqlaccess'
--debug=N
enter debuglevel N (0..3)
--copy reload temporary grant-tables from original ones
--preview
show differences in privileges after making changes in (temporary) grant-tables
--commit
copy grant-rules from temporary tables to grant-tables (!don't forget to do an mysqladmin reload)
--rollback
undo the last changes to the grant-tables.
NOTE
+ At least the user and the db must be given (even with wildcards)
+ If no host is given, `localhost' is assumed
+ Wilcards (*,?,%,_) are allowed for host, user and db, but be sure
to escape them from your shell!! (ie type * or '*')
SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
(1), replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with
no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mer-
curmedia.com)
19 December 2000 MYSQLACCESS(1)