XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / xoops and mySQL 4.1x in ISP (not local)
Register
1
plusangel
xoops and mySQL 4.1x in ISP (not local)

  • 2005/6/16 6:22

  • plusangel

  • Just popping in

  • Posts: 90

  • Since: 2005/2/2 1


Hello to all!

I'm stuck to the following known problem but I really want your help.

Till now, I had XOOPS on my local machines. I've tried it with mySQL4.0.23 (working perfect). Regarding mySQL4.1.x, I knew the compatibility problem with password encryption but as you proposed, I can solve it using the following FAQ:

https://xoops.org/modules/smartfaq/faq.php?faqid=483

A little time ago I decided to go live...my ISP using

php 4.3.10
mySQL 4.1.11
apache 1.3.33
and phpMyAdmin 2.6.1-pl2
cPanel 10.2.1

So I faced the same problem...not possible to install XOOPS in my ISP.
But I can not open mySQL dos shell (obviously from cpanel) and apply the proposed tip (SET PASSWORD command).


What can I do to overcome this problem?
Does anyone else have the same problem?
2
monde
Re: xoops and mySQL 4.1x in ISP (not local)

  • 2005/6/16 7:00

  • monde

  • Friend of XOOPS

  • Posts: 69

  • Since: 2004/11/15


Go to PHP MyAdmin and enter what you would have entered at the prompt as a query.

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

this is the same as the command line if you know how to structure your query.
3
plusangel
Re: xoops and mySQL 4.1x in ISP (not local)

  • 2005/6/16 9:28

  • plusangel

  • Just popping in

  • Posts: 90

  • Since: 2005/2/2 1


Thanks for the guidelines…

But I tried this in SQL window of the phpMyAdmin
and replies

#1044 - Access denied for user 'plus'@'localhost' to database 'mysql'

when I tried to execute the SET PASSWORD statement.

Probably I don’t have access as user of the ISP to do this or is something that I missing?
4
jdseymour
Re: xoops and mySQL 4.1x in ISP (not local)

Make sure the user that is accessing the database has full privileges.
5
plusangel
Re: xoops and mySQL 4.1x in ISP (not local)

  • 2005/6/16 10:03

  • plusangel

  • Just popping in

  • Posts: 90

  • Since: 2005/2/2 1


Ok, I’ll try to be more specific so that it will be easier for you to help me :)

'plus' is the username that ISP assign me in order to connect to cPanel and manage the site. When I’m selecting phpMyAdmin from the cPanel I’m logging in as plus @ localhost


In a previous step, using the mySQL databases from the site management menu of cPanel, I’ve created a database called xoops_db, a user called xoops_us and I’ve granted all permissions.

And here is the trouble:

I’m connecting to phpMyAdmin, open SQL window from the left menu (xoops_db is selected in the combo box)

And type:

SET PASSWORD FOR ‘xoops_us’@’localhost’ = OLD_PASSWORD(‘somepwd’);

And it replies

#1044 - Access denied for user 'plus'@'localhost' to database 'mysql'

Ouf!!!
6
jdseymour
Re: xoops and mySQL 4.1x in ISP (not local)

Next step would be to contact your host. Explain what you are trying to do and why. They should help you.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Aug 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!