| Author |
 Topic  |
|
|
Nick Feakes
New Member
99 Posts |
 Posted - 27 February 2016 : 14:06:33
|
I have a mysql database on one server that I can access through phpmyadmin (I haven't created any tables yet). My program files reside on a different server.
I have set: strDBType = "mysql"
This is my connection string:
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=91.232.148.9;user=nickfeakes;password=xxx;DATABASE=newtriplemforum;"
I get this message:
Code : 80004005
Error Description :
[MySQL][ODBC 3.51 Driver]Access denied for user: 'nickfeakes@TUNGSTEN' (Using password: YES)
I do not know where the "@TUNGSTEN" is coming from, my username is just nickfeakes?
Is it OK to have the database on a different server?
Nick |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 27 February 2016 : 16:51:43
|
| Have you created a user to access the database you created called "newtriplemforum". If you login to the MySQL server (which maybe called "TUNGSTEN" which is different to the dns name resolution name) using "nickfeakes", then do not use "nickfeakes" for the forum table access. Create a specific account for the forum and give it the permissions to create the tables and all the other stuff (but not the same as the admin account). |
Cheers,
David Greening |
 |
|
|
Nick Feakes
New Member
99 Posts |
Posted - 29 February 2016 : 08:05:12
|
Thank you David. At the moment I cannot add a user so I believe the person who created the database for me did not give me the correct privileges. I will report progress when I have that issue resolved.
Nick |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 29 February 2016 : 22:25:12
|
When you use phpmyadmin typically you are connecting the the mysql server that's also on the web server computer. If you're having problems connecting to mysql from a different computer, often the problem is because mysql is not open through your firewall and/or mysql hasn't been configured to allow access from the remote computer.
Learning the mysql command line can assist tracking down such problems, since you'll likely be able to see any error messages the cli connection attempt might have generated.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 01 March 2016 : 13:58:17
|
I can telnet to 91.232.148.9 on port 3306 (at the command box prompt, type telnet 91.232.148.9 3306 and press enter (CTRL+] and type quit to exit)), so would say that it is a permission issue given that the port is open.
Here is where you can learn about some of the: MySQL Commands Nick that Doug mentions |
Cheers,
David Greening |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 01 March 2016 : 22:04:17
|
quote:
I can telnet to 91.232.148.9 on port 3306 (at the command box prompt, type telnet 91.232.148.9 3306 and press enter (CTRL+] and type quit to exit))
But do you get prompted from the db server? My linux mariadb server (mysql fork) responds with "5.5.5-10.0.21-MariaDBTr_e\}#?#9618;p_kzD&/YStnKmysql_native_password^] to a telnet connection.
As far as I know if you don't get the identifying prompt to a telnet probe your mysql server isn't accessible. If mysql isn't running on port 3306 but the port is open through the firewall, you may get what appears to be a connection but it's not to the db server.
By the way, on windows 7+ you need to visit "add windows components" and install the telnet client to be able to use it from the windows cli.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Nick Feakes
New Member
99 Posts |
Posted - 03 March 2016 : 08:49:16
|
Doug & David
The person who set up the database and PHPMyAdmin insists I have the appropriate permissions but I can find no way to set up a user (the forum) using PHPMyAdmin. According to the help file there should be a "privileges" page but I do not have one of those.
Apologies for asking dumb questions but presumably I need to run some sort of test from the server where the forum resides to the server where the database resides to see if a connection is possible. Is that correct?
If so, how do I do that? I have ftp access to the forum server, is there some script I could run that might give me a clue?
Nick |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 03 March 2016 : 22:51:51
|
If your phpmyadmin is restricted to just your database and not all the db's on the server, then you also won't have permissions to manipulate users and other server settings. phpmyadmin can be configured for different access methods, and if you don't have admin user access to the mysql/phpmyadmin server machine you won't be able to change phpmyadmin settings, nor will you be able to manipulate the firewall on that server.
What kind of machine is the database server, your forum web server, and your workstation? I'm guessing you are running your forum web server on windows.
I like to use the command line client program 'mysql' from either linux or windows. It will exist on windows if you've installed mysql on the windows machine, probably you can download just the client from somewhere.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Nick Feakes
New Member
99 Posts |
Posted - 04 March 2016 : 08:18:00
|
Doug
My forum is running on a webserver hosted in the UK. The mySQL database is on a different server also hosted in the UK, it is shared hosting which I now think is the cause of the difficulty. Presumably I could ask the hosting people to set up the forum as a user with only read and write privileges but doesn't the setup file need full access to create the tables? I could set up the tables manually but that is prone to errors.
Thank you guys for the forum software and all the help you give.
Nick |
Edited by - Nick Feakes on 04 March 2016 16:46:40 |
|
|
|
Nick Feakes
New Member
99 Posts |
Posted - 18 March 2016 : 11:43:07
|
Thanks to all the help and particularly from David I now have my forum up and running having changed from an Access database to a MySQL database. I used a free program to migrate the entries in the database plus a bit of manual intervention to overcome the differences in the tables generated by setup.asp for the two databases. If there is any interest I will explain how I did it.
Nick |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 18 March 2016 : 17:49:02
|
| No problems Nick, I am glad I could help you and your group. Would be interested to know what program you ended up using to do the final migration... |
Cheers,
David Greening |
|
|
|
Nick Feakes
New Member
99 Posts |
Posted - 20 March 2016 : 16:04:53
|
David
I used Bullzip to create a dump file for each table (the total file was too large - there is a 32Mb limit). I then edited any "Insert" commands for tables that threw an error because the data type was incorrect by adding the column names in the sequence of the Access database so that the correct data ended up in the correct column (field) as the program didn't seem to want to do that for me even though that option was ticked. The other errors were due to missing columns (fields) where I had added mods to the original access database so I simply added those columns to the MySQL database that were missing.
A little tedious but not difficult, took me a couple of hours before I had the forum up and running. At the moment the forum is running using an old copy of the original access database as a test forum. This week I will shut down the forum, empty the MySQL database and repeat the dump file process with the latest version of the access database.
Nick |
Edited by - Nick Feakes on 20 March 2016 16:50:07 |
|
|
| |
Topic |
|
