Question about Sun MySQL

2 Answers

MYSQL Access denied

Hi,

First time I have taken a dedicated server and on that I have very less knowledge about MYSQL and Linux commands.

When I am trying to enter
shell>MYSQL
it is giving access denied message. Even when I am using
shell> mysql -u root -p
I am getting this error message "Error 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"

Can some please help in why >MYSQL is not working and how to retrrieve the mysql root password.

Thanks in Advance
Amjad

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

Hi Buddy,

Try this option....

mysql -u root -p

mysql will then ask you for the password give the proper password.

For changing mysql root password

mysqladmin -u root -p password <<newpwd>>

then mysql ask you to give password this is the old password and now the new password for the root will be newankush.

Posted on Sep 29, 2008

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

You can also use:

sudo -s

Then whatever code lines you need to have all permissions on the system

Posted on Feb 24, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to solve the mysql error 2003 Can't Connect to mysql server on 'localhost' (10061)


Your client software attempts to connect to a MySQL database instance on your local computer. There is no DB server running locally, hence the error.

Before reinstalling Windows, did you connect to a remote DB server or did you use a local instance?
In former case, you need to configure the DB connection to point to the remote serve. In the latter case, on top of Windows you also need to reinstall the MySQL DB server software locally, and it needs to be started.

Feb 27, 2013 | Sun MySQL

1 Answer

Cannot connect root@localhost error 1045


This is an access denied error. If you have specified a root password during install, you must supply it when you connect, e.g.:
mysql -p
will prompt you for the password.

Aug 23, 2011 | Sun MySQL

1 Answer

MySQL Error Number 1045 Access denied for user 'root'@'localhost' (using password: NO) If you want to check the network connection, please click the Ping button. That is the message i get when i...


Hi,

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installations is still needed to connect to the server. In this case please select skin now and re-run the Configuration Wizard from the start menu.


Please revert me, if you need more assistance, i would be very glad to assist you more.
If you were satisfied with the solution please rate this sollution.

Thanks For using FixYa!
Vinod Kumar J

Nov 28, 2010 | Sun MySQL

1 Answer

MySQL server at 'reading initial communication packet'


is the post open to read the mySql Server data ?

Jun 07, 2009 | Sun MySQL

1 Answer

I removed the password in phpmyadmin as i was using root/root Now nothing is working. I am using mamp Access denied for user 'root'@'localhost' (using password: YES


this might be what you are looking forr http://rudyegenias.wordpress.com/2006/09/15/enabling-phpmyadmin-once-you-change-permission-or-privileges-on-mysql-database/

May 12, 2009 | Sun MySQL

1 Answer

MySQL Database


THE SYSTEM REQUIRMENTS ARE
MySQL Tools
1. A SQL server : This is an engine which provides access to your databases.
2. Client programs for accessing the server : A program allows you to enter queries directly and view results
3. A client library for writing your own programs : You can write your own programs into the client library using C.
Recommended Hardware Requirements For Mysql Installation
  1. Pentium V processor
  2. 128 MB RAM
Note that MySQL can be installed on a platform with as little as 32 MB
RECOMENDED SOFTWARE TOOLS for better performance
IT is recommended to have at least 128MB memory.
You can freely download MySQL from the website http://www.mysql.com MySQL runs on many varieties of UNIX, as well as on other non-UNIX systems, such as Windows and OS/2. MySQL runs on hardware from home PCs to high-end server. MySQL can be installed on Windows XP, Windows Server 2003, Red Hat Fedora Linux, Debian Linux, and others

Sep 08, 2008 | Sun MySQL

1 Answer

Problem mysql


Hi,

I'm not a MySQL wiz, but i played around a bit, and found this.

This is SELinux blocking access to the socket. The easiest way to get around it is to:
1. run system-config-securitylevel (either from a bash prompt or the menus)
2. Select the SELinux Tab.
3. Click the Transition twistie.
4. Select Disable SELinux protection for httpd daemon
5. Click OK
6. Reboot your computer (I know, nobody likes to reboot, but when changing SELinux it seems to be a necessity.)
7. Profit!!!

Good luck, let me know how it went.

Aug 10, 2008 | Sun MySQL

1 Answer

MySQL can't connect Error


Guess you are referring to this error message -

cdfc6ee.jpg

Check your username & password, and make sure that you are authorized to access the server.

If your password & username are correct, there might be a network problem that prevents you from connecting to the machine where the MySQL server is running. To make sure that they are no network failures, click on the "ping" button.

This will "Ping" the MySQL server host. If the host is available (no network failure), you will

receive a message similar to this -

Reply from 127.0.0.1: Time=0ms TTL=128
Reply from 127.0.0.1: Time=1ms TTL=128

If you don't it means there's a problem with the network.

Jul 27, 2008 | Sun MySQL

4 Answers

MySQL Error Messeage


When you install MySQL for the first time, no password is set for root user.
Move to the installation directory of mysql (cd/usr/local/mysql) Set the password for user, using the following command -
./bin/mysqladmin -u <username> password

Enter your password. Then you can connect to the mysql client as
./bin/mysql -u <username> -p <password>

Jul 27, 2008 | Sun MySQL

Not finding what you are looking for?
Sun MySQL Logo

Related Topics:

477 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sun Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Justin
Justin

Level 3 Expert

2072 Answers

Are you a Sun Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...