Reputation
94,705
Next tag badge:
93/100 score
33/20 answers
Badges
12 109 238
Newest
 Nice Answer
Impact
~10.1m people reached

Apr
6
answered How to repair, or drop/create a corrupted table in mysql?
Apr
6
comment Why Can't I find my databases from Mysql on linux?
Did you login to MySQL like this : mysql -uroot -pmys3cr3t ??? From the looks of your error message, you did not specify the root user on the command line.
Apr
6
comment Why Can't I find my databases from Mysql on linux?
OK you will have to restart mysql like this : sudo service mysql restart --skip-grant-tables. This will get you to log into mysql without passwords. Login to mysql and run this: SELECT COUNT(1) RowCount FROM mysql.user WHERE user='root' and host='localhost'; What do you get for RowCount, 0 or 1 ???
Apr
6
reviewed Close How control 27 locations and 27 databases?
Apr
6
reviewed Close Which should I use on my DB? - Clustered Index or Non Clustered Index or Both
Apr
6
reviewed Close how to stop all Oracle instances
Apr
6
reviewed Close Import 10 Billion Rows, Daily
Apr
6
reviewed Leave Open Large RAM use after import database - ubuntu server
Apr
5
reviewed No Action Needed How to implement business logic permissions in PostgreSQL (or SQL in general)?
Apr
4
comment copy table comments from one MySQL database to another
Repeating Question : With the exception of the mysql schema, are all the table structures between Production and Test identical ???
Apr
4
revised copy table comments from one MySQL database to another
added 1168 characters in body
Apr
4
comment copy table comments from one MySQL database to another
Question: With the exception of the mysql schema, are all the table structures between Production and Test identical ???
Apr
4
revised copy table comments from one MySQL database to another
added 1168 characters in body
Apr
4
comment copy table comments from one MySQL database to another
That's a little harder. I'll explain why...
Apr
4
comment copy table comments from one MySQL database to another
Try running 'FLUSH TABLES' and see if the information_schema catches anything new.
Apr
4
revised copy table comments from one MySQL database to another
added 19 characters in body
Apr
4
answered copy table comments from one MySQL database to another
Apr
4
comment copy table comments from one MySQL database to another
Is the database very big ???
Apr
4
answered Why Can't I find my databases from Mysql on linux?
Apr
4
comment Why Can't I find my databases from Mysql on linux?
One more question : What version of MySQL is up on the Linux Server ???