Question about Sun MySQL

4 Answers

MySQL Error Messeage

Installed MySql (edition mysql-pro-gpl-4.1.24-win32) into - C:\ > programs files

When I click on mysql.exe I get this error message -

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

What am i doing wrong?


Posted by on

  • pishkari Aug 05, 2008

    i want to connect to mysql on server from a c# windows application

    when i want to open my connection I see this error

  • manujeffrey Nov 10, 2008

    i get error 1045 access denied for user 'root'@'localhost'(using password: YES)
    i forgot my password and cant reconnect im using windows vista.wat do i do

×

4 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 32 Answers

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>

Posted on Jul 27, 2008

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

Mysql is ****! i hate mysql! hate it! hate it!

Posted on Apr 03, 2010

  • polishpete13 Apr 03, 2010

    only joking! it just annoys me . . . . . .

    i can't get access into mysql thing! this error pops up ERROR NO. 1045 everytime i want to access! why is that?

×

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

The old password is a emty field.
Then use your password what you like.

FUN

Posted on Aug 02, 2010

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Another "fix" for this is to comment out the password property in hibernate.cfg.xml file. Since I'm only doing this to get some familiarity with hibernate its not necessary for me to have a password for my test.<!-- <property name="hibernate.connection.password">password</property> -->

Posted on Oct 16, 2012

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

How to fix mysql error 1046?


For the database import, before you attempt to import the "flat" file data in, you need go to your local DB (MySQL) and create new database
After that you can import!
Also check this links:
http://www.repairtoolforsql.fixtoolbox.com/ Fix Toolbox for MySQL
http://www.sqlservercentral.com/Forums/Topic1618894-2893-1.aspx

Apr 09, 2015 | Quest Software Toad for MySQL

2 Answers

How to fix mySQL corrupt databases?


you should follow two steps:

Create an appropriately named database on the target machine
Load the file using the mysql command:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Have a look how you can restore your tut_backup.sql file to the Tutorials database.
$ mysql -u root -p Tutorials < tut_backup.sql
To restore compressed backup files you can do the following:
gunzip < [backupfile.sql.gz] ' mysql -u [uname] -p[pass] [dbname]
If you need to restore a database that already exists, you'll need to use mysqlimport
command. The syntax for mysqlimport is as follows:
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Or make use of Repair Toolbox for MySQL

Demo version is here-: http://www.sql.repairtoolbox.com/

Feb 08, 2015 | Microsoft SQL Server 2000 Standard Edition...

2 Answers

Im getting a MySQL error saying : "Exception


Try to remove or rename your existing connection file, QB creates a new one if it does not find any existing, allowing so to recover from broken files.

MySQL Repair

Dec 27, 2010 | Sun MySQL

1 Answer

Im getting a MySQL error saying : "Exception EMyxError in module MySQLQueryBrowser.exe at 00111E52. Error while loading stored connections. Error Number 3."


I think your MySQL Server databases got corrupt.
Try to remove or rename your existing connection file, creates a new one if it does not find any existing, allowing so to recover from broken files from the utilies below-

MySql Fix Toolbox provides easy ways of MySQL fix

Worried for Losing Data due to MySQL Corruption

Dec 27, 2010 | Computers & Internet

1 Answer

MySQL server at 'reading initial communication packet'


is the post open to read the mySql Server data ?

Jun 07, 2009 | Sun MySQL

2 Answers

MYSQL Access denied


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.

Sep 10, 2008 | Sun MySQL

1 Answer

MySQL Error


This error means that mysql doesn't have sufficient memory to store the entire query result, so far no rocket science, the first thing you have to do is check your query it might be wrong, is it reasonable that it would return so many rows?

Aug 26, 2008 | Sun MySQL

2 Answers

Mysql Report Error


An example of getting feedback from MySQL about a PHP problem -

mysql_connect("my.site.com", "username", "password")
This can also be done with this code -
die(mysql_error())

Each of the above lines will return the errors, if you have problems connecting to your MySQL database.
There are many more ways, this is just a taste.

Jul 29, 2008 | Sun MySQL

1 Answer

MySQL problem


Make sure that when your InnoDB is looking for the ibdata1 file you have only one, sometimes you have more then one file & the system doesn't know which one to open.

Jul 27, 2008 | Sun MySQL

Not finding what you are looking for?
Sun MySQL Logo

Related Topics:

23,704 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sun Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Cosma Papouis
Cosma Papouis

Level 3 Expert

409 Answers

Are you a Sun Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...