20 Most Recent Sun MySQL Questions & Answers

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.

Sun MySQL | Answered on Aug 26, 2019

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.

Sun MySQL | Answered on Jun 10, 2019

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

Sun MySQL | Answered on Jun 13, 2017

David, what you're looking for is pivot table functionality. Unfortunately, that is not a built-in feature for MySQL (it is for SQL Server 2005/2008).
Not knowing your table structure, or the size/number of rows/columns, I found the following link to be most helpful example: MySQL Pivot Table Example

Sun MySQL | Answered on Sep 25, 2013

Hi David,

It looks like you're missing two more null's in the third record, the column count is only 21 and you have 23 fields in your destination table.

All your data matches up to the columns, but you'll need to insert ", null, null" before the last paren to cover CompanyURL and companyPhone):

('Karson', 'B', 'Campbell', null, 'Dr.', 'Chief Resident', 'Pediatrics', '[email protected]', null, null, '585-544-1212', 'home', '1955-01-05', 'Wife: Molly Kids: Cassidy, Justine, and Cory.', 'Mountain View Hospital', null, null, null, null, null, null, null, null, null, null )

Sun MySQL | Answered on Sep 24, 2013

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 -

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.

Sun MySQL | Answered on Apr 09, 2013

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>

Sun MySQL | Answered on Oct 16, 2012

could you give me more info plz

Sun MySQL | Answered on Jun 24, 2012

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

Sun MySQL | Answered on May 31, 2012

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.

Sun MySQL | Answered on Oct 29, 2011

you could refer to [email protected] in your connectionstring
this should resolve your problem when the database is on the same machine

Sun MySQL | Answered on Oct 25, 2011

When you connect to your database you need to supply the password you created for your database in the connection string

Sun MySQL | Answered on Oct 25, 2011

i have solution
please contact this number


Sun MySQL | Answered on Jun 25, 2011

Yes. In the SQL tab,

RENAME DATABASE test TO new_test ;

Sun MySQL | Answered on Jun 06, 2011

Not finding what you are looking for?
Sun MySQL Logo

53 questions posted

Ask a Question

Usually answered in minutes!

Top Sun Computers & Internet Experts

Rob Hill
Rob Hill

Level 3 Expert

1412 Answers


Level 3 Expert

8081 Answers

Sunny Solanki

Level 2 Expert

264 Answers

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

Answer questions

Manuals & User Guides

View Most Popular

Sun Computers & Internet

  • Sun Computers & Internet

Most Popular Question

restore mysql database windows tool

  • Computers & Internet