Viewing posts for the category MySQL

Creating and Updating MySQL Accounts / hosts.allow

Posted by: scoopseven in Linux MySQL 12 years, 9 months ago

Here's a quick script for creating or updating MySQL accounts via the command line so that you're able to login from any host. It's really easy to replace the '%' with your actual hostname or ip to make this more secure, so if at all possible, you should.

read more / 0 comments

Installing MySQLdb for Python / Django

Posted by: scoopseven in Django MySQL Python 14 years, 4 months ago

Problems installing MySQLdb? Me too! I'm installing using MySQL 5 / Django 1.1 / Python 2.4 on CentOS 5.4 linux.

read more / 0 comments

JDBC Connection Strings for Coldfusion 6.1 / CFMX

Posted by: scoopseven in ColdFusion Database MySQL 15 years ago

If you're trying to setup ColdFusion MX 6 with MySQL here's how you setup the MySQL datasources.  In CF Administrator go to Datasources and Add a New datasource of type "Other".  Enter your datasource name, username and password and the following fields like this:

read more / 0 comments

How to Dump and Import a Database or Table using the CLI on Linux

Posted by: scoopseven in Linux MySQL 15 years, 9 months ago

Log onto your server from the console or with a ssh client. I use Putty. Use the following command to dump a table.

read more / 0 comments

MySQL Reusing/Cached Connection Problem

Posted by: scoopseven in Database MySQL 15 years, 10 months ago

Problem with connecting to multiple databases within the same server is that every time you do:

read more / 0 comments