Sorry I dont know if this is the right place for this, but I think it is since it applies to a pre-requisite for installing a joomla bridge.
To bridge SMF and Joomla I need both MYSQL Databases to have permissions to each other. However my hosting company doesn't have cpanel so I have no idea how to do this.
Anyone know if I can do this my phpadmin or by editing the exported databases? Anyone know how??
any ideas would be great!!!
it would probably be easiest for you to install them in the same database.
Is there any other methods, right now i need two existing databases to interact with each other so a bridge will work.
Try this, and let me know if it works. If it does, I'll try to add this to the bridge config panel.
Go to phpMyAdmin. Go to your Joomla database.
Perform the following query. Change the values as follows:
Joomla_db_name = the name of your Joomla database.
SMF_username = the name of your SMF database user.
SMF_pass = the password of your SMF database user.
These values can be obtained from your Joomla configuration.php and your SMF Settings.php.
GRANT ALL ON Joomla_db_name TO 'SMF_username'@'localhost' IDENTIFIED BY 'SMF_pass'
If that works, I'll give you the other query to grant access on your SMF database to your Joomla database user as well.
Ran a query on that code and it gave me this
Error
SQL query:
GRANT ALL ON U3161026 TO 'kbrock3'@'mysql1034.servage.net' IDENTIFIED BY 'passhere'
MySQL said: Documentation
#1044 - Access denied for user: 'U3161026@%' to database 'U3161026'
Edit: edited out the pass for security reasons. but it was there and correctly. ;)
Yeah, mine gave me something similar as well. I was hoping that it might be possible to run the query from PHP, but if it doesn't work from PhpMyAdmin, there's no way it's going to work from a publicly-accessible script.
I'm sure there are cases where it would work, but we've obviously already found two where it won't. :-\