Login or Register to Ask a Question and Join Our Community

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

LEARN ABOUT LINUX

ndb_drop_table

NDB_DROP_TABLE(1)					       MySQL Database System						 NDB_DROP_TABLE(1)

NAME

       ndb_drop_table - drop an NDB table

SYNOPSIS

       ndb_drop_table options

DESCRIPTION

       ndb_drop_table drops the specified NDB table. (If you try to use this on a table created with a storage engine other than NDB, the attempt
       fails with the error 723: No such table exists.) This operation is extremely fast; in some cases, it can be an order of magnitude faster
       than using a MySQL DROP TABLE statement on an NDB table.
	       Usage

	   ndb_drop_table -c connect_string tbl_name -d db_name

       The following table includes options that are specific to ndb_drop_table. Additional descriptions follow the table. For options common to
       most MySQL Cluster programs (including ndb_drop_table), see Options Common to MySQL Cluster Programs(1).

       Table 17.19. ndb_drop_table Options and Variables: MySQL Cluster NDB 7.2
       +--------------------------+-----------------------------------+-------------------------------------+
       |Format			  | Description 		      | Added / Removed 		    |
       +--------------------------+-----------------------------------+-------------------------------------+
       |			  | Name of the database in which the | 				    |
       |       --database=dbname, | table is found		      |        All MySQL 5.5 based releases |
       |			  |				      | 				    |
       |       -d		  |				      | 				    |
       +--------------------------+-----------------------------------+-------------------------------------+

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							 NDB_DROP_TABLE(1)
All times are GMT -4. The time now is 06:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy