Database name and DB username change.
Moderator: General Support Moderators
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
-
- Joomla! Apprentice
- Posts: 7
- Joined: Fri May 09, 2008 1:45 pm
Database name and DB username change.
I use a hosting service and have been forced to change the database name and DB username because of an upgrade from mysql v3.23 to v5. What must I do to my joomla 1.5 install in order to be able to access the db with the new DB name and username? The password has not changed.
Thanks.
Thanks.
- CodeLab
- Joomla! Intern
- Posts: 92
- Joined: Wed Aug 29, 2007 11:07 am
- Location: India
Re: Database name and DB username change.
I Think Just Changing Appropriate Details In Configuration.php Is All You Need To Do.
-
- Joomla! Apprentice
- Posts: 9
- Joined: Sat May 10, 2008 2:18 pm
Re: Database name and DB username change.
I am having trouble understanding what to change in my 'configuration.php' file
I hope someone can help with this :
these seem to be the key items that need changing:
if the database lives here :
http://www.micelistudios.com/4healing
what do I set the above values to be ? I seem to have tried all options but I still get this message:
Database Error: Unable to connect to the database:Could not connect to MySQL
I hope someone can help with this :
these seem to be the key items that need changing:
Code: Select all
var $log_path = '/home/users/web/b1228/sl.jdfadver/public_html/4healing/logs';
var $tmp_path = '/home/users/web/b1228/sl.jdfadver/public_html/4healing/tmp';
var $ftp_root = '/public_html/4healing';
var $host = 'jdfadver.startlogicmysql.com';
var $smtphost = 'jdfadver.startlogicmysql.com';
http://www.micelistudios.com/4healing
what do I set the above values to be ? I seem to have tried all options but I still get this message:
Database Error: Unable to connect to the database:Could not connect to MySQL
- CodeLab
- Joomla! Intern
- Posts: 92
- Joined: Wed Aug 29, 2007 11:07 am
- Location: India
Re: Database name and DB username change.
Make Sure, Values For Database Information Are Correct In Your Configuration.php File
var $dbtype = 'mysql';
var $host = 'localhost'; \\ Mostly You Can Leave It As Localhost
var $user = 'YOUR DB USER'
var $db = 'YOUR DB NAME'
var $dbprefix ='jos_'
var $password = 'YOUR DB PASSWORD'
var $dbtype = 'mysql';
var $host = 'localhost'; \\ Mostly You Can Leave It As Localhost
var $user = 'YOUR DB USER'
var $db = 'YOUR DB NAME'
var $dbprefix ='jos_'
var $password = 'YOUR DB PASSWORD'
-
- Joomla! Apprentice
- Posts: 9
- Joined: Sat May 10, 2008 2:18 pm
Re: Database name and DB username change.
thanks so much for the reply. I have 1 question :
What about the path to the database ?
My database lives on a different server, do I need the absolute path to that database
...I just don't know where I need to enter that in the 'configuration.php' file.
What about the path to the database ?
My database lives on a different server, do I need the absolute path to that database
...I just don't know where I need to enter that in the 'configuration.php' file.
- CodeLab
- Joomla! Intern
- Posts: 92
- Joined: Wed Aug 29, 2007 11:07 am
- Location: India
Re: Database name and DB username change.
Ok Database path Goes Here
var $host = 'DB HOST/PATH'
You Cannot Put Localhost Here,
You Can Find In Your Control Panel, What To Use As DB Host
Mostly It Will Be An IP Address
Or Ask From Your Hosting Service About Database Access Host...
var $host = 'DB HOST/PATH'
You Cannot Put Localhost Here,
You Can Find In Your Control Panel, What To Use As DB Host
Mostly It Will Be An IP Address
Or Ask From Your Hosting Service About Database Access Host...
-
- Joomla! Apprentice
- Posts: 9
- Joined: Sat May 10, 2008 2:18 pm
Re: Database name and DB username change.
thanks. can you put in a sample of what that might look like ?
is the path the absolute path like : www.somedomain.com/directory1/subdirectory
var $host = 'DB HOST/PATH'
is the path the absolute path like : www.somedomain.com/directory1/subdirectory
var $host = 'DB HOST/PATH'
- CodeLab
- Joomla! Intern
- Posts: 92
- Joined: Wed Aug 29, 2007 11:07 am
- Location: India
Re: Database name and DB username change.
Database Server Cannot Be Something Like
http://www.somesite.com/somedir
It Is The Server, Not The Directory
It Will Be Some IP Address Like
213.167.25.213
Or It Can Be Server Name.
You Can Find It In Your Control Panel Or Ask From Your Hosting Service...
http://www.somesite.com/somedir
It Is The Server, Not The Directory
It Will Be Some IP Address Like
213.167.25.213
Or It Can Be Server Name.
You Can Find It In Your Control Panel Or Ask From Your Hosting Service...
-
- Joomla! Apprentice
- Posts: 9
- Joined: Sat May 10, 2008 2:18 pm
Re: Database name and DB username change.
i see. thank you so much for your replies...this helps a great deal.
One more small question.
The PATH can be something like this...right ?
/www.somesite.com/somedir
One more small question.
The PATH can be something like this...right ?
/www.somesite.com/somedir
- CodeLab
- Joomla! Intern
- Posts: 92
- Joined: Wed Aug 29, 2007 11:07 am
- Location: India
Re: Database name and DB username change.
If You Are Talking About Configuration.php Parameters Like
var $log_path
var $tmp_path
And So On, Then These Have Path Like
'/home/users/web/b1228/sl.jdfadver/public_html/4healing/tmp' ......
I Dont Think
www.somesite.com/somedir
Kind Of Paths Will Work For
var $log_path And var $tmp_path
And Yeah I Would Like To Know If You managed To Bring Your Site Up In Working
var $log_path
var $tmp_path
And So On, Then These Have Path Like
'/home/users/web/b1228/sl.jdfadver/public_html/4healing/tmp' ......
I Dont Think
www.somesite.com/somedir
Kind Of Paths Will Work For
var $log_path And var $tmp_path
And Yeah I Would Like To Know If You managed To Bring Your Site Up In Working
-
- Joomla! Apprentice
- Posts: 9
- Joined: Sat May 10, 2008 2:18 pm
Re: Database name and DB username change.
thanks again. your going to kill me with all these questions, but I have one more.
this : "/home/users/web/b1228/sl...'
is it always home ? I notice every joomla config file uses this "home" and "users" and "web" what do these stand for ?
and the "b1228" and "si" I am not sure if this is something I should include either ?
thank you so much, it is getting clearer!
this : "/home/users/web/b1228/sl...'
is it always home ? I notice every joomla config file uses this "home" and "users" and "web" what do these stand for ?
and the "b1228" and "si" I am not sure if this is something I should include either ?
thank you so much, it is getting clearer!
- CodeLab
- Joomla! Intern
- Posts: 92
- Joined: Wed Aug 29, 2007 11:07 am
- Location: India
Re: Database name and DB username change.
Its Path Of Your Sites Directory On Your Server
I Think It Always Starts With /home
You Can Actually Compare This To Something Like
C:\Docs\Something\Something\Folder\
As A Path To Some Directory On Your Local Computer
Genreally Its Like This
/home/<YOUR USERNAME>/public_html
But Depends On Your Server...
Hope This Helps
I Think It Always Starts With /home
You Can Actually Compare This To Something Like
C:\Docs\Something\Something\Folder\
As A Path To Some Directory On Your Local Computer
Genreally Its Like This
/home/<YOUR USERNAME>/public_html
But Depends On Your Server...
Hope This Helps
- LukeDouglas
- Joomla! Explorer
- Posts: 260
- Joined: Sat Dec 08, 2007 8:23 pm
- Contact:
Re: Database name and DB username change.
I have attached a document I created and use to secure my clients Joomla installations. Feel free to distribute to your friends and associates if you feel it is a good guide.
You do not have the required permissions to view the files attached to this post.