Posts Tagged ‘mysql server’

I want to use in-memory tables for improved performance in MySQL. But what is the cleanest way to ensure that the tables reload (from on-disk tables) when the MySQL server restarts? Is there any way to configure this natively within MySQL, without resorting to Perl and similar external script hacks? Thanks

Packaged in MySQL installer are the main server and the commandline client. Do I need to install another server on the remote PC?

I want to use commandline and batch scripts because I don’t have any idea about PHP when accessing MySQL server… or am I doing it correctly anyway? Help me.

I have a program that runs in a local computer that wants to connect to a remote mysql server on http://www.bluehost.com how can i connect it there? what are the procedures? what is the connection string?

How can I restore an sql dump file to a mysql server?

I accidentally deleted all the default databases like mysql and test and information_schema and now, when I click localhost, it says 1130 – Host ‘localhost’ is not allowed to connect to this MYSQL server

I have a mysql server up and running on my local machine, but I can’t seem to get a simple php script to execute on it. I thought I had php installed correctly. Is there some special folder I have to save the script in to make it work. I have it in my bin folder right now. Is there an easy way to know whether I have php installed correctly or not?

I want to run a MySQL server and a microsoft SQL server one the same computer.

Will I encounter problems doing this? Are they compatible?

I keep getting this error:

Error connecting to MySQL server: Access denied for user ‘root@localhost’@'localhost’ (using password: YES)

How am I supposed to know what the username and password are?