External Mysql Server

how could i use an external plesk server
My plesk os is windows 2008
External Mysql server Centos

also this sql server is a remote server of cpanel which is on an other cent os so the table names must be different how could i give different structures ?

Thanks
LVL 1
CahitEyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steve BinkCommented:
I'm not sure I understand your question.  Are you asking how your web application on  your Plesk server can use a MySQL database on another server?
0
CahitEyAuthor Commented:
1-> windows server (plesk)
2-> linux server (centoos)
3-> mysql server (centos)

this are my servers and i want to make it sth like this.
when s.b creates a db on plesk with mysql it will be created on 3rd server not on 1
i have do this on cpanel easily at the other side as i told cpanel uses this server for mysql too so there wont be any same named db, i need to make special prefix for db name
0
Steve BinkCommented:
Log in to Plesk.  From the main Plesk page, click on "Server", then click on "Database Servers".  Click on "Add Server" to define the server you want to use.  Look at the preferences page for your special naming.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

CahitEyAuthor Commented:
I could not see any option like this under server menu
0
Steve BinkCommented:
Are you logged in as the server admin?  What version of Plesk?
0
CahitEyAuthor Commented:
plesk 9.1 or 9.2 i am not sure :D
yes i have logged as admin
0
CahitEyAuthor Commented:
Incorrect string value: '\xC4\xB0rem' for column 'ads' at row 2
this is a select query result for irem on ads column

chr.png
0
CahitEyAuthor Commented:
Pardonme wrong wwhere to write
0
Steve BinkCommented:
I'm a little new to Plesk 9, so I may be missing something.  On my installation, I click on "Settings", then click "Database Hosting Preferences".  That screen is used to set the object name prefix.  Go up a level from there to get to the database servers screen.
0
CahitEyAuthor Commented:
i have two option under settings tab -> database preferences :
1)Select MS SQL WebAdmin
2)Database Hosting Preferences
nothing more
0
Steve BinkCommented:
Select #2.  You can set the object name prefix on that screen.  Go up a level from there to get to the database servers screen.

It looks like they left out a direct link to the database servers.
0
CahitEyAuthor Commented:
but where is database servers i could not find it :S
0
CahitEyAuthor Commented:
i have found this : (maybe sth. could be interested in with this)
If VZ MSDE template was installed after remote database servers were set up in Parallels Plesk Panel, working with remote database servers will be forbidden because VZ MSDE template switches the work mode from remote to local. To resolve this issue, you have to manually switch the work mode from local to remote.
but i do not know what is this :D
0
Steve BinkCommented:
0
CahitEyAuthor Commented:
yesss :D but one last question should i change the prefix ?
0
Steve BinkCommented:
I do not believe you can change the prefix.  It looks like Plesk uses a naming system, if you select that option.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CahitEyAuthor Commented:
i mean ->
insteadof this
username_Dbname
i want to make it sth like this
win_username_dbname
0
CahitEyAuthor Commented:
Thank you for all your help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.