Why Can't I find my databases from Mysql on linux?

Let’s learn why Can't I find my databases from Mysql on linux. The most accurate or helpful solution is served by Database Administrators.

There are ten answers to this question.

Best solution

Why Can't I find my databases from Mysql on linux?

I'm new to linux. I cannot get a list of my databases by typing SHOW DATABASES on the MySQL shell. Though this MySQL program is aware of the MySQL datadir because it is listed when I type SHOW VARIABLES LIKE "%dir", as datadir = /var/lib/mysql. I am logged in as root. Normally on windows, I would type SHOW DATABASES on the MySQL command console that comes with WAMPSERVER and I'd get a list of all available databases on the localhost.

Answer:

Your problem has nothing to do with missing databases. You real problem stems directly from the way...

Read more

okeyxyz at Database Administrators Mark as irrelevant Undo

Other solutions

Software Professional with 4 years exp. in PHP,Mysql,Linux,AjAX,XMl.How to find a Job in Mumbai for this?

I have 4 years of experience in Linux,Apache,Mysql and PHP with good understanding of OOPS concepts.I have sound knowledge of AJAX,Javascript,HTML and CSS.I am trying to find a job in ...show more

Answer:

Better to switch over to some other place like bangaloge,chennai

Read more

C7734CSJBVSX2WBN7MXUUQWSZI at Yahoo! Answers Mark as irrelevant Undo

Using PHP to find MySQL databases...?

I want "username" to be stored into a variable and then check if the MySQL database exists with that name..I am making a site and whenever someone registers, a new DATABASE, not Table, DATABASE is created. I DONT want them to press submit but...

Answer:

You'll probably have to use AJAX to do what you're describing. AJAX is a technique in which you use...

Read more

Ben at Yahoo! Answers Mark as irrelevant Undo

Where can I find free virtual labs that offer live access to products like F5, Cisco routers and switches, Juniper firewalls, Microsoft Server Products, Linux, VMware, Xenserver, HyperV, Qemu, Clustered Databases and the like?

Not everyone can afford the hardware required to build a lab that includes a well configured network, servers, virtualization with load balancers and clustered databases.  I don't expect something like this exists, but would love to know what exists...

Answer:

The labs I have found useful thus far: Microsoft Labs. Best lab so far.  Pretty cool I think.  This...

Read more

David Alistair at Quora Mark as irrelevant Undo

In mysql 5.1.40, what's the error "You can't use locks with log tables" on mysql.general_log & mysql.slow_log?

I have mysql 5.1.40 on my linux webserver. Running mysqlcheck there are 2 errors in the mysql database: mysql.general_log Error : You can't use locks with log tables. status : OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql...

Answer:

Running table checks implicitly locks the table (equivelant to executing 'LOCK TABLES') to prevent concurrency...

Read more

Tocci at Yahoo! Answers Mark as irrelevant Undo

Redundant MySQL Redundancy

What's the best way to ensure 99.999% service of a MySQL server? I'm looking for information on best practices for redundancy, and what the best way to acheive hot-failover would be ... or if it's better to use a cluster. Here's the technical details...

Answer:

"hardware raid 0+1" Careful; you want RAID 1+0 for redundancy -- i.e. you want to mirror,...

Read more

SpecialK at Ask.Metafilter.Com Mark as irrelevant Undo

MySQL dump/import command

I am not interested in a collection of links to sites that offer all sorts of explanations of all the command line switches for doing this (I could find these myself). I want a researcher who knows the answer with confidence to respond to this question...

Answer:

Hello, I manage a couple forums in MySQL which have different tables & data which need to be backed...

Read more

mork-ga at Google Answers Mark as irrelevant Undo

Where does MySQL store its database?

In any operating system, but especially Linux, where does MySQL store all the databases? If in Linux, which directory is the data stored in? I want to create a database server but want to make sure that I get a separate hard drive for all the MySQL data...

Answer:

Mysql keep its data in /var/lib/mysql folder incase you feel to reinstall the mysql you can allways...

Read more

hamzalam at Yahoo! Answers Mark as irrelevant Undo

Laid off from non-profit job. Can I transition into Linux sysadmin work?

I'm about to get laid off from my non-profit job within the next month. I was hired as a general office admin person, and ended up doing mainly Linux sysadmin work. What are my chances of getting this type of work as my next job? Details and snowflakes...

Answer:

Put it all on your resume and apply for Sys Admin jobs. You have been woefully underpaid. It doesn't...

Read more

winterhill at Ask.Metafilter.Com Mark as irrelevant Undo

Recommend me a laptop for Linux

LinuxLaptopFilter: Can you recommend me a laptop for Linux? I originally had a ThinkPad 600E. Yeah, the one with the chipset/soundcard/modem problem (I tried SuSE 8.1, 8.2, 9.0 and Ubuntu). Now the battery is as dead as the dodo. And it weighs a tonne...

Answer:

Ubuntu seems to be supported on iBooks and PowerBooks. The 12" iBook seems to list at £...

Read more

xpermanentx at Ask.Metafilter.Com Mark as irrelevant Undo

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.