MySQL problems
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySQL problems
MySQL problems
14-05-2008 12:07 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I can access mysql through Plusnets phpMYAdmin on both servers fine.
I made the database in Microsoft Access 2007, which has a feature to upload directly to mysql. If I put in the following settings it comes up with a connection error:

I have also tried installing a front-end called 'dadabik' onto my ccgi webspace, when I run the install.php I get the following error:
'Warning: mysql_connect(): Can't connect to MySQL server on 'mysql.plus.net' (4) in /share/storage/01/bl/blueshed/MPIndex/include/adodb/drivers/adodb-mysql.inc.php on line 358
[06] Error: during database connection.'
I am using the following settings in the config script:
// dbms type ('mysql'|'postgres7'|'postgres8'|'mssql'|'oci8po') (oci8po is Oracle)
$dbms_type = 'mysql';
// DBMS server host
$host = 'mysql.plus.net'; // the name or the IP of the host where the DBMS is running e.g. "localhost"; for mssql you may need the instance name too e.g. "127.0.0.1\SQLEXPRESS"
// database name
$db_name = 'blueshed_pn';
// database user
$user = 'blueshed'; // this user must have select, insert, update, delete permissions, create and drop permissions are also needed for installation and administration area e.g. 'root'
// database password
$pass = '**********';
// DaDaBIK complete url (e.g. http://www.mysite.com/path_to_dadabik/)
$site_url = 'http://ccgi.blueshed.plus.com/MPIndex/';
// DaDaBIK url path (e.g. if $site_url is http://www.mysite.com/path_to_dadabik/ this should be /path_to_dadabik/)
$site_path = '/MPIndex/';
I also cannot access mysql with 'Navicat' a mysql admin application.
Is it the settings that I am using or is there some problem with accessing the mysql?
Cheers
Re: MySQL problems
14-05-2008 12:10 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Phil
Superusers are not staff, but they do have a direct line of communication into the business in order to raise issues, concerns and feedback from the community.
Re: MySQL problems
14-05-2008 12:19 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
rumpus.plus.net seems to work for Navicat but Microsoft Access doesn't seem to want to work, I'm not entirely sure why.
Edit: Looks like Navicat can import database files anyway, so I may not need access.
Re: MySQL problems
14-05-2008 12:33 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Quote from: pjmarsh I've never heard of mysql.plus.net
It's the web address for phpMyAdmin

Re: MySQL problems
14-05-2008 1:29 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Phil
Superusers are not staff, but they do have a direct line of communication into the business in order to raise issues, concerns and feedback from the community.
Re: MySQL problems
16-05-2008 7:00 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
1: I think the database name would have to be "blueshed_pn", you only get one "database" with each account AFAIK
2: I'm not sure if Plusnet even allow direct access, I think its set up so only the CGI server (and admin server) can access it
Re: MySQL problems
17-05-2008 12:34 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page