Sponsored Content
Full Discussion: Forgot MYSQL password root
Top Forums Web Development Forgot MYSQL password root Post 302879057 by hergp on Tuesday 10th of December 2013 09:24:05 AM
Old 12-10-2013
If you want the mysql command to ask for a password, use the -p option
Code:
# mysql -p
Enter password: Type the password here
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1809
Server version: 5.1.69 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 

9 More Discussions You Might Find Interesting

1. HP-UX

forgot password

i forgot my password on a HP-UX 9.xx machine. is there a possible way of changing it without knowing the root passwd? I would do it with a boot disk and chroot but I dont have a boot disk available.... any ideas? thanks!! Paul Tittel (1 Reply)
Discussion started by: paultittel
1 Replies

2. UNIX for Dummies Questions & Answers

I forgot my UNIX password!!

Hello, Is there a way to reset the "root" unix password, pretty much like you would do in linux by going into single user mode? :confused: :confused: Thank you in advance. (5 Replies)
Discussion started by: Mr Big
5 Replies

3. Red Hat

forgot root passwd

hi i have a RHEL 4 and have forgot root passwd tried to boot in by singel user and then changing the passwd but it's not letting me do that ......throwing some weird error as .......manipulation i also tried to make a new user from CLI but even though it's not letting me in from that user as... (12 Replies)
Discussion started by: techbravo
12 Replies

4. Solaris

forgot password

hello friends, I am currently using solaris 10. I have lost the root password. Can you please give me a step by step procedure on how to set the password again. (11 Replies)
Discussion started by: nsharath
11 Replies

5. UNIX for Advanced & Expert Users

Not able to reset mysql root password

Hi, My root password for mysql has some problem as it dosent allow me to login.... all commands to reset it failed. so I removed mysql yum remove mysql and installed it by yum install mysql mysql-devel mysql-server and it installed fine I gave chkconfig --levels 235 mysqld on... (1 Reply)
Discussion started by: viji19812001
1 Replies

6. UNIX and Linux Applications

Obfuscating mysql root password

I would like to set the root password for mysql databases installed on various machines connected within a network. These machines receive their mysql installation via a script that pulls the installation files from the server and starts installing. During installation I would also like to set the... (0 Replies)
Discussion started by: figaro
0 Replies

7. UNIX for Dummies Questions & Answers

Forgot root password

i am a new user of unix . i lost my SGI unix server root password Any body please help me,how get password? (2 Replies)
Discussion started by: vasu.k82
2 Replies

8. Solaris

How to reset forgotten mysql root password?

Hi All, I just found one thread on this forum on this subject here: Forgot MYSQL password root | Unix Linux Forums | Web Development but unfortunately the issue was not resolved. I have the same problem with the same error message. The background is that I built a Solaris 11 x86 server... (11 Replies)
Discussion started by: hicksd8
11 Replies

9. UNIX for Beginners Questions & Answers

I have forgot my root password. Solaris 10

hi everyone i have forgot my root password and i have other user to login. can i get the password without restarting the server as that cant be afforded. . it is a Sparc architecture 2U blade server. it is old server mounted and functional since 2009. what should be the modus oprandee. i am novice... (5 Replies)
Discussion started by: janakors
5 Replies
MYSQL_CLIENT_TEST(1)					       MySQL Database System					      MYSQL_CLIENT_TEST(1)

NAME
mysql_client_test - test client API mysql_client_test_embedded - test client API for embedded server SYNOPSIS
mysql_client_test [options] [test_name] ... mysql_client_test_embedded [options] [test_name] ... DESCRIPTION
The mysql_client_test program is used for testing aspects of the MySQL client API that cannot be tested using mysqltest and its test language. mysql_client_test_embedded is similar but used for testing the embedded server. Both programs are run as part of the test suite. The source code for the programs can be found in in tests/mysql_client_test.c in a source distribution. The program serves as a good source of examples illustrating how to use various features of the client API. mysql_client_test is used in a test by the same name in the main tests suite of mysql-test-run.pl but may also be run directly. Unlike the other programs listed here, it does not read an external description of what tests to run. Instead, all tests are coded into the program, which is written to cover all aspects of the C language API. mysql_client_test supports the following options: o --help, -? Display a help message and exit. o --basedir=dir_name, -b dir_name The base directory for the tests. o --count=count, -t count The number of times to execute the tests. o --database=db_name, -D db_name The database to use. o --debug[=debug_options], -#[debug_options] Write a debugging log if MySQL is built with debugging support. The default debug_options value is 'd:t:o,/tmp/mysql_client_test.trace'. o --getopt-ll-test=option, -g option Option to use for testing bugs in the getopt library. o --host=host_name, -h host_name Connect to the MySQL server on the given host. o --password[=password], -p[password] The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one. o --port=port_num, -P port_num The TCP/IP port number to use for the connection. o --server-arg=arg, -A arg Argument to send to the embedded server. o --show-tests, -T Show all test names. o --silent, -s Be more silent. o --socket=path, -S path The socket file to use when connecting to localhost (which is the default host). o --testcase, -c The option is used when called from mysql-test-run.pl, so that mysql_client_test may optionally behave in a different way than if called manually, for example by skipping some tests. Currently, there is no difference in behavior but the option is included to make this possible. o --user=user_name, -u user_name The MySQL user name to use when connecting to the server. o -v dir_name, --vardir=dir_name The data directory for tests. The default is mysql-test/var. COPYRIGHT
Copyright (C) 2006, 2013, 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 01/23/2014 MYSQL_CLIENT_TEST(1)
All times are GMT -4. The time now is 10:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy