Question about Sun MySQL

1 Answer

SQL command not working

I went to the mysql prompt and typed ./bin/mysqladmin -u root password;
I get "You have an error in your SQL syntax" and it flags the entire line of code. You said "go to the installation directory of mysql (cd/usr/local/mysql)", is the same as the mysql prompt? 'Also, am I supporsed to be using 'root' as the username?

Posted by on

  • Jill Torgerson Jul 30, 2008

    femster,



    I was attempting to use the mysqldump command to convert my .frm files to a .sql file on my local machine. I was getting an ACCESS 1045 error because the username 'root' had never been associated with my password. I then attempted to create that association using the 'mysqladmin -u username -p password' command that was offered by several people, including you. I kept getting an error. I noticed from the postings that numerous other people were getting the same result. Turns out there shouldn't be spaces between the '-u' and 'username' or the '-p' and password, a simple point that wasn't stated explicitly. When I entered 'mysqladmin -uroot -ppassword', it worked.

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 71 Answers

Could you give me more info plz

Posted on Jul 30, 2008

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 restore MySQL database Windows tool?


You can restore corrupt and delete SQL database file in few steps for MySQL Restore Toolbox. With this software you can also recover triggers, keys, indexes and table. Software support multiple MDF file recovery option. Software is supported by all Windows operating system. Get more ideas and download free trial version from -http://www.filerepairforum.com/forum/databases/databases-aa/mysql/1162-dump-mysql-database-file-is-error

May 29, 2015 | Sun MySQL

1 Answer

How to move one mysql database to another machine


After logging into MySQL via command prompt, use the below commands.
Backup :
databasename > dumpfile.sql
Restore :
source dumpfile.sql

If you have an IDE like HeidiSQL or SQL Yog, they can make tasks easier through visual interfaces.

Mar 12, 2013 | Compilers & Programming Tools

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

8 Answers

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in...


Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskey SQL Password Recovery, which is a professional program enables you reset administrator or user password for Microsoft SQL Server instantly regardless of the length, complexity, language and encoding of the password set before. As long as you got AnyPasskey SQL Password Recovery and master.mdf file, you could reset SA password on any authorized PC in minutes without the installation of Microsoft SQL Server. What's more, this featured-in tool supports all versions of Microsoft SQL Server and Microsoft SQL Server Express perfectly. 6_21_2012_1_55_07_am.jpg

Sep 15, 2010 | Compilers & Programming Tools

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

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

4 Answers

Table Repair MySQL


MySQL offers Check Table syntax that checks a table or tables for errors. It works for several storage engines like MyISAM, InnoDB, & Archive. If you run this syntax then you can the cause of problem & reported tables.

If Check Table finds errors then you can repair reported tables by Repair MySQL Table syntax.

Aug 06, 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:

140 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

18299 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...