Connection problem to a MySQL database

I am not a MySQL programmer and try to do any work through the Query Browser and Administrator.

In my site's control Panel Plesk I created a database called ACCFMCA with the user name FWB and say a password of pwd.

I then made a simple table of 3 fields called items.

I can connect to the database with MySQL Query Browser and In MySQL Administrator it shows FWB connected. When I go to User Administration I get the error - "Could notfetch user names. The following error occurred. SELECT command denied to user FWB@67.69.20.4 for table 'user' (1142). Under Server Connections it shows user FWB as active.

This appears to be a permission problem, but I can't see where to get at permissions when there is no user.

This problem ends up not allowing me to connect to the database from Dreamweaver.

How do I fix this?
fbaillieAsked:
Who is Participating?
 
tkfastCommented:
If you have a sec I have made the changes and you should be able to just connect and go in the connections folder and get the file members.php from the server and I tested it and it works just changed it to localhost.

If that does not solve your problem let me know I want to get you up and running my goal was by monday.

I think Toronto is central time.  (my sister is dating a toronto citizen)   I do not make it to the office till 10:00is central time.  I work very late.  Just give me a call anytime.

~ ~ ~ ~

What to do next time to solve the problem:
First change to you local setting and put the connections folder up on the server.  

Then test your connection.  You want to make sure you Database password and username is what you set when it was setup in plesk.  

Why do you have the Members one set to localhost:3306 change it to localhost


In the MYSQL Connection in Dreamweaver
Connection Name:  name it what ever you want
MySQL Server:  localhost
Username:  it is your database username you set in plesk
Password:  What you have set in plesk for that database
Database:  What you have as the name of the database

databases              usernames that you have for each database
ACCFMCA              Fixer           or    FWB
Members                accfmca        or     cgiscript
0
 
tkfastCommented:
did you reload your permissions on the mysql server?  After you make any permission changes you have to reload permissions.    mysqladmin reload on the command-line or flush privileges at the mysql command-line client.
0
 
fbaillieAuthor Commented:
I don't seem to have the permissions to do any of that.

Can I login as root and if so how do I tell mysql which database root is trying to access?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
tkfastCommented:
If you have root access or any user access the command you run to pick the database is USE  

Is this a server you have root access to or what control panel solution do they have for you to use and I might able to help you with that particular option.  Is it opening into phpmyadmin?  

http://dev.mysql.com/doc/refman/5.0/en/use.html
0
 
fbaillieAuthor Commented:
Yes - it's opening phpMyAdmin .

phpMyAdmin 2.6.4-pl3

MySQL 4.1.20 running on localhost:3306 as FWB@localhost
0
 
tkfastCommented:
When you logon do you have an option for  Privileges ?  This should be available when you press the house icon on the left.  Click on the Privileges then go to the very bottom of that screen and you will see reload the privileges click that and you should be set.  

When you created the user under the host option did you set it to localhost as the location that has access to the user or Any Host of did you specify something else?

Let me know

http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki
0
 
fbaillieAuthor Commented:
I'm connected to 69.72.217.242:8443/localhost

Under the MySQL column it says
Create a new database
No Privelages

In MySQL Query Browser I exectuted SHOW GRANTS with the following results

GRANT USAGE ON *.* TO 'FWB'@'%' IDENTIFIED BY PASSWORD '295523f33800043d'
GRANT ALL PRIVILEGES ON `ACCFMCA`.* TO 'FWB'@'%'

Aren't those two opposite?
0
 
tkfastCommented:
You must be using Plesk?  port 8443 is the plesk control panel port.  The setting permission will have to be done under plesk.  You should be able to create a user and password under your plesk control panel to add permissions to a database.  

Plesk Video on how to do it
http://www.swsoft.com/doc/tutorials/Plesk/Plesk7/plesk_plesk7_eu/plesk7_eu_mysql.htm

Let me know if that is what you are looking for!
0
 
fbaillieAuthor Commented:
Thanks a bunch. I'll have a look and be back to you.
0
 
fbaillieAuthor Commented:
OK - I did that and created a new db with a new user.

When I went into php MyAdmin I still see the "NO PRIVILEGES" and no way that I can see to set them.

Am I nuts?
0
 
tkfastCommented:
when you created the database you setup a user and that is the user and the password that you will be using to access the database.  do you have ssh access to the server we can test some mysql commands on the server to see if it the database is on anther server.  I'm not a huge fan of plesk we just phased it out completely as we just had nothing but problems with it.  we have been using it for the past 4 years and just got fed up.  
0
 
tkfastCommented:
from phpmyadmin you can do everything?  right?  In dreamweaver.   If so here are the steps to setup dreamweaver.

  http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_16575&sliceId=1 

you might ask you webhosting company if the database resides on the server the website is on that might mean you have to do localhost or the external ip of it.  It depends on how they have it setup.  

Please let me know i want to get you taken care of i just need a little more info....
0
 
fbaillieAuthor Commented:
The only ssh access that Plesk tells me about is for uploading files

Plesk help file

"If your are using a Linux or FreeBSD operating system on your local computer and have access to server shell, use the 'scp' command to copy files and directories to the server: scp your_file_name login@remoteserver.com:path to copy files, and scp r your_directory_name login@remoteserver.com:path to copy entire directories."

I can't do anything in  phpmyadmin as I have no privileges. Drteamweaver still gives me the access denied error.

I will ask my host about this, and I'll let you know.
0
 
tkfastCommented:
If you can scp to the server then you should be able to ssh to the server.  Putty is a program that will allow a windows system to connect to a linux system and the scp is also available to file transfer in windows and that is winscp.  Try using the putty software to connect to the server with your username and password then we can try some of those commands that I sent in the last article.  The winscp is nice for copying files back and forth you might put it in your software library both softwares are open soure so they are free to use as well.  

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

http://winscp.net/eng/download.php
0
 
fbaillieAuthor Commented:
I've used previous versions of putty but I'm having trouble getting it to connect. I'm getting a connection refused.

winscp does connect just like any other ftp server.
0
 
tkfastCommented:
When you are running Putty did you select SSH?  I know this might be crazy but it should allow you to connect if they allow outsize ssh but who knows they can block it..  Without having access to command line of the mysql I can not rule out them as the problem or you dreamweaver config.  I feel bad but I thing I'm stuck telling you to ask the isp to fix it...  If you can share with me who the isp is then I can do little more on how to connect to them.  I'm sorry.... Does everything work fine when you are connected to phpmyadmin?  If so we just need to fix your dreamweaver.
0
 
fbaillieAuthor Commented:
No I still get the "No Privileges" error in phpmyadmin.

I was trying in SSH with no luck. Where do you put the password in? I tried putting it in as an environmental variable.
0
 
tkfastCommented:
If you do not have permission in phpmyadmin that is directly connected to the database and if it does not work there then it wont work other places.  Aka get rid of plesk it complicates it....
0
 
fbaillieAuthor Commented:
I wish I could cPanel is MUCH better. I may have to change my host although their service has been good so far.

I'm using Host Nexus to host about 17 sites and I may need to leave them , any ideas of a better host?
0
 
tkfastCommented:
Here is how they tell you to setup the database.  

http://www.nexusportal.net/support/general-hosting/phpmyadmin/dbcreate.html

I cant make recommendations as a part of my company does that so I would not be a valid opinion sorry.  I can just tell you we gave up on the plesk option due to the problems we had been having and it makes it even more complicated for a client to admin.   We completely wrote our own panel to make customers account.  If you up for changing your password I can logon and see if I can help you or I can start a vnc connection to you and we can work though it together just let me know.  It makes it frustrating when you are trying to learn and something out of your control is stopping you.  
0
 
fbaillieAuthor Commented:
I'm getting embarrassed by the amount of time you've spent on this! If your company sells reseller web space and gives the support you've given me maybe I should know about it.

My site is - americancoach-fmca.com, the Plesk user name is - americancoach-fmca.com and the password is 272727.

The URL for the Plesk panel is https://69.72.217.242:8443/login.php

Anything you can figure out would be MUCH appreciated.

Frank

PS where are you?
0
 
tkfastCommented:
I have looked over the site and I have added a test use tried to connect still have problems I need to setup ftp to test it if you want when you get a free moment you can connect to me and I can try to fix is on your system.  It looks like we might just need to setup your dreamweaver.  Its sometimes touch.  What version of dreamweaver are you running?  If it's 8 you migh want to do this update it improves a vast amount of the functionality of the system.

If you can try this in the dreamweaver config set the  mysql server to localhost try that, then try 65.98.120.122 and also try 69.72.217.242.  You have a shared/exclusing server and It might be only configed for certain ip's to have access to it.  

You might also ask them if you can get ssh bash access to the server tell them you are doing mysql database work and it would be nice for troubleshooting to have log access so I can get my config to work.  

 http://www.adobe.com/support/dreamweaver/downloads_updaters.html#dw8

I'm in Wichita, KS

Just give me an update and we can teleconference if need be lets get this taken care of before Monday is my goal.  
0
 
fbaillieAuthor Commented:
The ftp user name and password are the same as you have - accfmca and 272727.

Could that be a problem?

I'm using Dreamweaver CS3 which I believe is the latest version.

you can log into my computer using Logmein - https://secure.logmein.com/home.asp?lang=en it's free. My email is frank@compwiz.ca and the password is fatfrank. You should see my machine as "Screamer" - don't I wish.
0
 
tkfastCommented:
Ok It works just fine I created a new database tkfasttest and I made the connection I wanted to find out what setting you have in your dreamweaver.  When you create the new connection you have to make sure you upload the new php file that exists in your Connections Folder on you local system.  When you get in just give me a call and we can connect to one another.  I tried that software and it is asking for some windows username and password but I would like to help you get it taken care of I have it all working now on my testing database with the webhost.  steven@tkfast.com Or give me a call.  877-TKFAST1 x 2200
0
 
fbaillieAuthor Commented:
I'll give you a call tomorrow.

Please tell me a time that's good.

I'm in Barrie Ontario, just North of Toronto..
0
 
fbaillieAuthor Commented:
I'm a bit confused with this BUT - I'll try to figure it out !

Toronto is in EST, I'll try to phone you tomorrow.

What's your name?

Frank Baillie
0
 
fbaillieAuthor Commented:
I'm totally confused at this point as to how to connect, from which program and how.

I obviously am not conversant with the correct verbiage here.

I'll call tomorrow.

I've set up a, for now temporary host which uses cPanel and WHM. I'm used to those and maybe I can do better there if we can't fix it without taking too much more of your time. I should have access to it tomorrow - pm.
0
 
tkfastCommented:
Steven,  Sounds good I will talk to you tomorrow....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.