Sponsored Content
Top Forums Web Development Error when trying to set Admin password in MySQL Post 302430076 by Corona688 on Wednesday 16th of June 2010 01:14:35 PM
Old 06-16-2010
That's not the command to set the root password, just the command to login with mysqladmin and run the command new_password (which probably isn't a command at all).

To set the root password in mysql, login as root with mysql -uroot -p, then follow this syntax to change the password.

If you do not have the current root password you'll need to follow this procedure to reset it. It involves running the mysql daemon in a special 'safe mode'.
 

8 More Discussions You Might Find Interesting

1. Cybersecurity

Web site Security WRT MySql - how set up?

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

Resetting forgotten admin password

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

How to reset SC admin password in Netra T2000 server?

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

set mysql password with host parameter

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

help|how to rest my password admin(root)

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

How to recover Admin password

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

Recover Admin Password

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

help reset netra T1 lom admin password

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
MYSQL_CONFIG(1) 					       MySQL Database System						   MYSQL_CONFIG(1)

NAME
mysql_config - display options for compiling clients SYNOPSIS
mysql_config options DESCRIPTION
mysql_config provides you with useful information for compiling your MySQL client and connecting it to MySQL. It is a shell script, so it is available only on Unix and Unix-like systems. mysql_config supports the following options. o --cflags Compiler flags to find include files and critical compiler flags and defines used when compiling the libmysqlclient library. The options returned are tied to the specific compiler that was used when the library was created and might clash with the settings for your own compiler. Use --include for more portable options that contain only include paths. o --include Compiler options to find MySQL include files. o --libmysqld-libs, --embedded Libraries and options required to link with the MySQL embedded server. o --libs Libraries and options required to link with the MySQL client library. o --libs_r Libraries and options required to link with the thread-safe MySQL client library. In MySQL 5.5, all client libraries are thread-safe, so this option need not be used. The --libs option can be used in all cases. o --plugindir The default plugin directory path name, defined when configuring MySQL. o --port The default TCP/IP port number, defined when configuring MySQL. o --socket The default Unix socket file, defined when configuring MySQL. o --version Version number for the MySQL distribution. If you invoke mysql_config with no options, it displays a list of all options that it supports, and their values: shell> mysql_config Usage: /usr/local/mysql/bin/mysql_config [options] Options: --cflags [-I/usr/local/mysql/include/mysql -mcpu=pentiumpro] --include [-I/usr/local/mysql/include/mysql] --libs [-L/usr/local/mysql/lib/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl] --libs_r [-L/usr/local/mysql/lib/mysql -lmysqlclient_r -lpthread -lm -lrt -lssl -lcrypto -ldl] --socket [/tmp/mysql.sock] --port [3306] --version [5.5.31] --libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld -lpthread -lm -lrt -lssl -lcrypto -ldl -lcrypt] You can use mysql_config within a command line using backticks to include the output that it produces for a particular option. For example, to compile and link a MySQL client program, use mysql_config as follows: shell> gcc -c `mysql_config --cflags` progname.c shell> gcc -o progname progname.o `mysql_config --libs` COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Oracle Corporation (http://dev.mysql.com/). MySQL 5.5 01/30/2014 MYSQL_CONFIG(1)
All times are GMT -4. The time now is 10:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy