Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Connection problem to a MySQL database

Posted on 2007-10-13
28
Medium Priority
?
348 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:fbaillie
  • 14
  • 14
28 Comments
 
LVL 5

Expert Comment

by:tkfast
ID: 20071485
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
 

Author Comment

by:fbaillie
ID: 20071596
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20071617
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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

Author Comment

by:fbaillie
ID: 20071638
Yes - it's opening phpMyAdmin .

phpMyAdmin 2.6.4-pl3

MySQL 4.1.20 running on localhost:3306 as FWB@localhost
0
 
LVL 5

Expert Comment

by:tkfast
ID: 20071658
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
 

Author Comment

by:fbaillie
ID: 20071754
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20072042
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
 

Author Comment

by:fbaillie
ID: 20072077
Thanks a bunch. I'll have a look and be back to you.
0
 

Author Comment

by:fbaillie
ID: 20072095
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20072227
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20072260
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
 

Author Comment

by:fbaillie
ID: 20072379
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20072768
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
 

Author Comment

by:fbaillie
ID: 20072852
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20072871
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
 

Author Comment

by:fbaillie
ID: 20072882
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20072904
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
 

Author Comment

by:fbaillie
ID: 20072910
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20072966
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
 

Author Comment

by:fbaillie
ID: 20073621
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20074128
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
 

Author Comment

by:fbaillie
ID: 20074223
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20075087
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
 

Author Comment

by:fbaillie
ID: 20075318
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
 
LVL 5

Accepted Solution

by:
tkfast earned 2000 total points
ID: 20075340
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
 

Author Comment

by:fbaillie
ID: 20075576
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
 

Author Comment

by:fbaillie
ID: 20075638
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
 
LVL 5

Expert Comment

by:tkfast
ID: 20075711
Steven,  Sounds good I will talk to you tomorrow....
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month21 days, 1 hour left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question