#1  
Old 3rd September 2006, 01:54
jang jang is offline
Junior Member
 
Join Date: Aug 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL access question

I have created a database "NAME" in Mysql as root user using the shell.

I have setup two sites in ISP Config from one client. How can I make access to the database "NAME" from the two sites?

Should i get access with web1_u1, web2_u1 or setup a new user. I tried it with adding a new user "A" with privileges in the Manager PHPmyadmin, but that doesn't work. I still get a 'no database selected' error in my two sites. I connect with

$conn = mysql_connect("localhost", "A", "password");
mysql_select_db("NAME",$conn);

What should I change?

The point is a have a big zipcode database that I want to share, not setup twice in the two domains.

Jang
Reply With Quote
Sponsored Links
  #2  
Old 3rd September 2006, 02:08
Ben Ben is offline
Moderator
 
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts
Default

If you created the mySQL user independent of ISPConfig you don't have to do anything with it. What you have to do is to use it when connecting with the defined user and password.

The no database selected error could mean, as I guess, that you created a user giving it no right to access any database, so you have to create the databse as well and let the user access this.

But to make it more ease for you, just create the stuff with ispconfig, you can use any username / database created with that independent of the web you use.
Reply With Quote
  #3  
Old 3rd September 2006, 12:42
jang jang is offline
Junior Member
 
Join Date: Aug 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thx Ben, I have it working now.

I'm not sure how I solved it, because I tried exactly what you told me before I asked my question. Probably a typo somewhere

One other question that puzzles me is the information_schema database that seems to be there for every user.
Why is it there and what is the use of that?

Jang
Reply With Quote
  #4  
Old 3rd September 2006, 18:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Quote:
Originally Posted by jang
One other question that puzzles me is the information_schema database that seems to be there for every user.
Why is it there and what is the use of that?
This are internal data structures from mysql. Just dont care about them
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 4th September 2006, 11:37
jang jang is offline
Junior Member
 
Join Date: Aug 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

I just wonder what will happen when customers start editing them.

They will be confused anyhow by the existence, I guess
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR: The PHP binary coming with ISPConfig does not work properly on your system! qvindesland Installation/Configuration 22 21st May 2007 16:05
Perfect Ubuntu 5.10 question (MYSQL) Lord_Garfield HOWTO-Related Questions 3 1st September 2006 16:18
Can't Remote Access mysql 4.1 dedibox Installation/Configuration 2 24th August 2006 10:32
Questions in regards to ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" rbrantley HOWTO-Related Questions 16 10th April 2006 18:26
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 05:26.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.