close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQL Privilege Issues

Thread began 2/24/2010 11:16 pm by msjj000 | Last modified 3/02/2010 4:23 pm by Jason Byrnes | 4686 views | 16 replies |

msjj000Beta Tester

MySQL Privilege Issues

Hi WA,

Have been trying to get through the install script however I am stuck at enabling the create view option.

I keep getting the following error when using the MySQL query window. I've contacted my hosting providing and they referred me to the web.

The best result I get is below.

+++start_error_copypasteerrormessage+++
Error

SQL query: DocumentationEdit

GRANT SELECT ON dbname TO username@'localhost' IDENTIFIED BY 'password';

MySQL said: Documentation
#1045 - Access denied for user 'username'@'localhost' (using password: YES)
+++end+++

Secondly, I'll need to run the script to copy the data from PowerStore v2 to v3 - is it a simple cut and paste into the query window?

Can you provide some guidance please?

Thanks, Mark.

Sign in to reply to this post

mrs

Hi, 'Jon' seems to be having a similar problem in this post here:

showthread.php?t=10603

I posted a response on a work around that I managed to get to working for myself... let me know if this works for you. You will need to load it on your local testing server first, then upload the files and the database. Once the database is uploaded, you'll need to make changes as mentioned.

Hope that helps.

Sign in to reply to this post

msjj000Beta Tester

Hi mrs,

Thanks for that. I must admit that I became very used to the "manual" setup in PowerStore1 & 2.

That threat still talks about the need to have create view enabled and this is my stumbling block. I've looked at numerous references to check my syntax like w3schools.com and ntchosting. What worked for you?

Thanks, Mark.

response below:
Error

SQL query: DocumentationEdit

GRANT SELECT ON databasename TO username@'localhost' IDENTIFIED BY 'abcd';

MySQL said: Documentation
#1045 - Access denied for user 'username'@'localhost' (using password: YES)

Sign in to reply to this post

Jason ByrnesWebAssist

you need to substitute your MySQL username for username@'localhost'.

On my server, i use the 'root' user, with a password of '123'
so the SQL is:
GRANT SELECT ON dbname TO 'root'@'localhost' IDENTIFIED BY '123';



you also need to change dbname to the name of database to add the select privileges to. In my case the name of the database is 'ps3':
GRANT SELECT ON ps3 TO 'root'@'localhost' IDENTIFIED BY '123';

Sign in to reply to this post

msjj000Beta Tester

Originally Said By: Jason Byrnes
  you need to substitute your MySQL username for username@'localhost'.

On my server, i use the 'root' user, with a password of '123'
so the SQL is:
GRANT SELECT ON dbname TO 'root'@'localhost' IDENTIFIED BY '123';



you also need to change dbname to the name of database to add the select privileges to. In my case the name of the database is 'ps3':
GRANT SELECT ON ps3 TO 'root'@'localhost' IDENTIFIED BY '123';  


Hi Jason,

okay something isn't working here for me.

I get the following message returned
MySQL said: Documentation
#1142 - GRANT command denied to user 'databaseusername'@'localhost' for table 'nameofdatabase'

when using:
GRANT SELECT ON databasename TO 'databaseusername'@'localhost' IDENTIFIED BY 'userdatabasepassword';

I have tried root and its associated password. Do I need to start with a database as the install program looks like it doesn't create one until after this point? I have uploaded the store.sql and tried that also.

Isn't the install program designed to make things easier?

Jason, would appreciate any additional help you may be able to offer.

Thanks, Mark.

Sign in to reply to this post

Jason ByrnesWebAssist

yes, a database needs to be created first.

you need to use valid values,

your command:
GRANT SELECT ON databasename TO 'databaseusername'@'localhost' IDENTIFIED BY 'userdatabasepassword';


would only work if you had a database that was named "databasename", and there was a user created in MySQL named "databaseusername" with the password set to "userdatabasepassword" I highly doubt this is the case.

you need to use a valid database name, a valid user name and the password associated with that user.

Sign in to reply to this post

msjj000Beta Tester

Hi Jason,

Thanks for coming back so quick. Yes I created a database (via importing store.sql) and created a user for the database in WebAdmin. I changed the name to ensure that I had the right detail in the right spot - hence the naming convention so you could see what I was entering and where.

Looks like l may be entering the correct detail without having any luck. Are there any different syntax changes between MySQL v4.x, 5.x and MSSQL? This is really bogging me down - is there an alternative way around this?

Thx, Mark.

Sign in to reply to this post

Jason ByrnesWebAssist

have you set the permissions for the new user you created through the web admin to be able to use the database?

On the database screen, there is a place to select the users that allowed to connect to that database, you must select the new user you created as an allowed user to connect to the database.

Sign in to reply to this post

msjj000Beta Tester

Hi Jason,

Yes, Once you create the database via Plesk/WebAdmin you then add the user to the database from within that databases interface. The connections have worked fine in PowerStore v2 using the connections.php file as an alternative example.

Where should we go from here?

Thanks again, Mark.

Sign in to reply to this post

Jason ByrnesWebAssist

the error is specifically saying that the Create View privilege could not be granted.

This is an issue for you to work out with your hosting company. It looks like they have disabled the ability for you to grant the Create view Privilege.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...