Mysql To Virtual Domain
I have a dedicated server with 5 virtual domains under iis.
i just installed mysql. how do i create a separate instance of mysql for
each of my virtual domain so that one domain affects only tables created by
that domain and not step on tables of other domain?
let's say that each virtual domain is a separate web site with different
fqdn
View Complete Forum Thread with Replies
Related Forum Messages:
Virtual Domain
I have a dedicated server with 5 virtual domains under iis. i just installed mysql. how do i create a separate instance of mysql for each of my virtual domain so that one domain affects only tables created by that domain and not step on tables of other domain? let's say that each virtual domain is a separate web site with different fqdn
View Replies !
MySQL Virtual Hosting
When you create a new user, let's call him "userJohn", is it possible to set a different data foler for that user? I was thinking it would be great if you could keep user databases seperate from each other, kind of like every user has thier own folder on a virtual database folder, and access can be restricted for that user to the databases in their folder. So if user1 creates a database named "Database1", and later user2 creates a database with the same exact name, it will not give an error, and when user1 alters his "Database1," it will not effect any other users "Database1". Similair to webhosting, where every user has their own folder they keep thier data in.
View Replies !
Mysql Db On Another Domain
www.domain1.com has a script that saves the last login of users. the script needs to save to a mysql DB on another domain's DB table (www.domain2.com - MySQL DB). Password and user for domain2 DB is provided. is it possible to connect/save data to a mysql db on another domain
View Replies !
Accessing MySQL DB From Another Domain
what is the best way to access data in a MySQL database on one domain from a PHP script on another. We have a secure (SSL) server on one domain which will be used for secure credit card transactions. We would like to be able to extract insecure contact information from MySQL database on another domain in another hosting environment.
View Replies !
Cannot Connect To Mysql On 1 Domain
i have several domains all connecting successfully to mysql, but recently, 1, has refused to connect giving the dreaded "1045 access denied etc" message. I have made a new user granting all privileges, but stll errors. i have tried connecting with: mysql administrator, dreamweaver amongst others. any help or guidance would be gratefully received as i need to get this sorted quickly as i cannot see where else to go with this. cheers MySQL 4.1.22-standard
View Replies !
MySQL Domain Deleted
I have Windows 2003 server Web edition and use PLESK. Yesterday a domain was deleted using PLESK. Under this domain I had created MySQL user and this user was deleted too when domain was gone.
View Replies !
Using MySQL/PHP On Someone's Domain.
You know if you wanna connect to mysql through php in the localhost you just do: $db = mysql_connect("localhost", "user", "password"); mysql_select_db("database", $db); Now.. what if I wanna put.. lets say the database on a web space I got from my ISP. Questions are: Which files do I need to put on the webspace? How do I connect to it? Do I need to do anything first?
View Replies !
Rename Domain Name In Mysql Database
In certain table I want to change the word mydomain.com by mynewdomain.com everywhere it appears, any column, any row. Is there a way to perform this without downloading the table, making the changes and upload it again?
View Replies !
Virtual Fields
Is there a way to do a mysql select with - for lack of a better word - a 'virtual field'. In other words, I'd like to select on a field that is based on the contents of other fields. Like: If field A is greater than field B, select field A, otherwise select field B Specifically, I'm working with date fields. I have a table of events where there is a start date and an end date. Most events are one day only, so they have only the start date. I would like to select and sort on the latest date field - either the end date or, if there isn't one, the start date.
View Replies !
Db On A Virtual Web Server
i am running my web server with dsvr.co.uk. a uk based web server hosting company. I am trying to use a piece of software called smoothflash at the moment to show pics. dsvr have informed me that I have mysql on my server but i cannot for the life of me work out how to connect to a db, een to create a new db. www.smoothflash.com has the install manual on it and it all seems to straight forward. I know I have enabled mysql on my server, this has been varified by dsvr. but then I have no idea how I am meant to create a db, connect to it, i have mysql admin for windows but without knowing how to create a db, get a user name and password for it i have no idea how to get any further, if any of you clever people out there could help me in this matter i'd forever be in your debt.
View Replies !
Virtual Column
I want to get users informations from multiple tables and each user has many dependants (in tbl_dependants) and the dependants table has user_id foriegn key. Is it possible to SELECT user informations and beside the user results I create a virtual column contains dependants names for each user?¿?
View Replies !
Virtual Folder
in my database i have a table which stores a directory structure folderstructure table id, foldername, parentid parentid points to its parents "id" (:p ) i need to retrieve this info so that its sorted by foldername and its children are listed below also sorted by foldername; there can be a infinite amount of nested folders.... im not really sure how to go about this; i was hoping that maybe theres some magical sql statement that can do this for me i sort of dont want to put this info in a array then sort it with recursion (which i tried and failed), nor do i want loads of sql queries
View Replies !
Using Virtual Column In WHERE Clause
SELECT IF( some_id > 3, 'foo', 'bar' ) AS 'virtualcolumn' FROM table WHERE virtualcolumn = 'foo' MySQL will complain that 'virtualcolumn' is unknow in WHERE clause. However, if I have another query like SELECT IF( some_id > 3, 'foo', 'bar' ) AS 'virtualcolumn' FROM table ORDER BY virtualcolumn ASC .
View Replies !
Not Working With Virtual Host
I set up a virtual host with Apache and my previously-working MySQL configuration now will not work! I did this a long time ago and can't remember how to fix the problem...Do i need to change some configuration so that MySQL runs on the virtual host and not localhost?
View Replies !
Chew So Much Virtual Memory On Windows?
Have a fairly busy MySQL server using MyISAM and InnoDB tables on Win 2003 with plenty of available RAM (total 4GB, with about 1.5GB unused) which is using a massive amount of virtual memory despite having tweaked MySQL to use as much memory as it needs. RAM usage never gets much above 400MB, however Windows is reporting that MySQL is using a massive 1.5GB of virtual memory. Most other processes use a similar amount of RAM and virtual memory, so why would MySQL be using 4~5 times more virtual memory than physical memory? Especially when there is so much free physical memory?
View Replies !
My Domain Name
I've been trying to get MySQL to work for the last week. I've tried looking all over the web but nothing seems to work.My domain name links to a directory on my home computer. I'm running Windows with Apache, PHP, and now MySQL. Apache and PHP work fine and I can connect to MySQL on localhost, but when I try to connect to (my domain name) it keeps giving me the "can't connect on 10061" error. I'm entering "mysql -h (my domain name) -u guest -p". I made a user named guest and as I said, can connect if I use "mysql -h localhost -u guest -p." mysqld.exe is running as a service. Window's firewall is disabled. Can't connect using mysql_connect in PHP either.
View Replies !
Can I Have My Db On Different Domain
I've goto migrate a website to a new server, is there anyway (in the connection string) that i can continue to reference the old server (which houses mysql) and have the website on the new server and then be able to switch the connections strings when we are happy with the migration and we don't lose that much data.
View Replies !
Store DB For Each Domain
if there is a way to set up MySQL server to keep DB's for one user in it's home folder? I wonder how those virtual (shared) hosting companies set it up? What I mean is say if I have two users (domains) on the server they will have all their files in their home folders. /home/domain1.com/ /home/domain2.com/ I ask this because I find it neat to have all the files for one domain in one place - mostly for backup.
View Replies !
Domain Values
I have table which has a column called URL, in which different formats of urls are stored. I want to read hostname, www.domain.com, from url column and strip out remaining data. I was reading regexp manual and i think it cannot be use before WHERE clause e.g select url regexp '' from table but at the same time i saw this functionality on another website so it is doable.
View Replies !
Removing A Domain
I added a new domain but by mistake i inserted an incorect username from what the client wants. how can i change it, or remove the user and redo it.
View Replies !
Transferring Of Domain
I would transfer a domain from an hoste to another, and I'dlike to transfer databases, also. I encountered someproblems with phpMyAdmin, and I thought: IT IS POSSIBLE TO CONNECT TO A SERVER AND BACKUP A DATABASE WITH MYSQL ADMINISTRATOR, or another MySql tool? How to configure the connection?
View Replies !
Storage Of Domain Names
I'd like allow user to enter domain names in a form and then to store these in a table field in MySQL.Googled this bigtime butdidn't find anything on it. What I would need is the regex poliching of the domain names (I guess I cannot put slashes into the database without caution, right?
View Replies !
Configuring XAMPP In The Domain
I am installing my XAMPP in my pc. It works fine. Everything works. My question is, is it possible to install XAMPP inside in my domain e.g., www.mydomain.com/xampp. Please help me to configure it using the domain, not in the localhost.
View Replies !
Regexp Matching *.domain.com
I don't think this is possible, but perhaps it's just beyond me? I have a database of domain names. other1.com *.test.test.com test.com *.other2.com How can I validate domain name search like "test.com" = valid domain "other.test.com" = invalid domain "other.test.test.com" = valid domain Here's my attempt, but i'm not even close. SELECT * FROM `dns` WHERE `DNS_Lookup` REGEXP ^([^.asterisk.])([.period.])(".$_DNS_SEARCH.")$';";
View Replies !
Grant All Privileges On Domain
how do i grant the privileges for user on the domain?? this one for a specific ip adress GRANT ALL PRIVILEGES ON *.* To root@'192.168.0.112' IDENTIFIED BY ''; how to make it for the domain?
View Replies !
Domain Name Now Doesnt Work
I have a software script I had installed on my server that works with a mysql database. It was working fine as far as pulling information from the database under my old domain name, however, I changed to a new domain name as primary on my server and now the database does not pull anything into the template. I know this is probably simple but not sure how to fix this.
View Replies !
General Log For Single Database/domain
Is it possible to have general_log setup for a single database or domain on a server with multiple databases and domains? I would like to monitor a single domain, but it's not required for the entire database server.
View Replies !
Query For Attribute Type/domain
How can I find out the type of an attribute through a SQL query. For instance, if I have a table and one of it's fields/attributes/columns/whatever is "name" and is of type "tinytext" how can I, through a SQL query (such as mysql_query() in php) get "tinytext".
View Replies !
LOAD DATA INFILE (using UNC, Windows Shares) On A DOMAIN Controller
Since we migrated MySQL on a Faster and Better Server we have some problems with LOAD DATA INFILE and OUTFILE command. Since this could be a permission problem i really don't know.... example. 1 load data infile '//server//myfile/test.txt' into table a; got errno: 13 if i remember correct FILE NOT FOUND. however typing servermyfile in Start->Run Works ok without authorization. MYSQL-SERVER: Mysql is on Windows Server 2008, All network passwords are saved inside OS on user accounts. So I tested that in Windows and Shares All Fine. -this machine is not on a DOMAIN. But authorization works ok with saved passwords and user names Server: (where the file is): Windows Server 2003 SP1 SBS Domain Controller , AD. Other App, Main APP whitch is 32bit uses MySQL on that other server there... -all works fine but UNC paths and authentication does not seem to go... -tryed some tricks... not sure if it will work... I'll try on Monday... However: I tryed to Use My Linux machine that has Samba installed. And i got there some anonymous shares that do not require any authentication at all. And MySQL works fine at that point. LOAD DATA INFILE executes fine.... samba log : mysql connects using UNC without any user name or password.... did not find any kind of user name or password sent using this method.... Maybe MySQL should just add this kind of function to my.ini..... I'll write if I find a solution fast on Monday.... Since I think this is more of a PERMISSION problem on Windows.... Should installed Linux on that machine though!:(
View Replies !
User@localhost And User@domain.com
I have been following a tutorial for a mail server which uses mysql, mainly postfix all through the tutorial i have been asked to put a user and password in the files for the database.. which i have done root and pass1 in the log files the error shows as warning access denied for user root@domain.com ( using password : yes ) when i log on from the shell, to mysql and purpously get the password wrong, I get access denied for user root@localhost ( using password : no ) i have checked the password is correct.. is the part after the @ the issue, and how can i tell mysql that root@domainname.com is a valid user???
View Replies !
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
View Replies !
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
View Replies !
ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment: ASP.NET ver 2 MySQL 5.0 FP Extensions 2003 Progression: Developed Website Outline Developed Database in Access2003 Migrated AccessDB to MySQL @ Hosting Service using Migration Tool. Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there. PROBLEM: (The heart of the matter) Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get: "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online. ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away" Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.
View Replies !
Could Not Load MySQL Driver! Compile Php --with-mysql Or Install The Mysql.so Module.
I am trying to install Media Wiki 1.5.2 on Windows XP and I have already installed apache_2.0.55-win32-x86-no_ssl ,mysql-5.0.15-win32 and php-5.1.1-Win32 . When I am trying to install Media Wiki 1.5.2 I receive the following message : Warning: dl() [function.dl]: Not supported in multithreaded Web servers - use extension=mysql.so in your php.ini in C:Program FilesApache GroupApache2htdocsmediawikimediawiki-1.5.2install-utils.inc on line 17 Could not load MySQL driver! Please compile php --with-mysql or install the mysql.so module.
View Replies !
Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (11)
We run Bitrix CMS and upon installing the web statistics module, it will sometimes show this error: Error! mysql_connect('-', '-', '-') Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) The max connections has been raised to a 1000... and SHOW GLOBAL STATUS says for the maxed used connections: Max_used_connections 273 The server does not really max out...
View Replies !
How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net has worked fine for me in the past. Now I'm trying 192.168.1.106 Database Name - whatever, mysqldb works fine, any valid db User - root Password - myrootpass Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now SQL Command On Connect - haven't ever put anything here Perhaps there is some configuration in mysql user privilege for the mysqluser "root" that would prevent him from logging from a remote PC to the mysql server?
View Replies !
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
View Replies !
MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it. So ... I get the following error when I try to connect: MySQL Error Number 2003 Can't connnect to MySQL server on 'hostname'(10065) Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:
View Replies !
Table Rows Inserted By Embeddded MySQL Cannot Be Retrieved By MySQL Tcp Client
I have encountered a weird behavoir of embedded MySQL. Through a simple program I made (in Delphi 6), I can insert rows to a table through embedded MySQL and I can retrieve the rows from my program. But using mysql.exe which points to the same table (through 127.0.0.1, with the same basedir and datadir), I cannot see the rows I inserted using my embedded program. Another way around, the rows inserted by mysql.exe can be seen in my embedded program. But after a row is inserted by mysql.exe, the rows inserted by the embedde program are deleted (or cannot be queried). Can anybody explain why is this? Is there a way to fix it?
View Replies !
DBD::mysql::st Execute Failed: Lost Connection To MySQL Server During Query
I am using perl to connect to a database and then pull the rows off of the table one by one to manipulate the data. If I use a smaller table (~8 MB), I wait for around 20 seconds but then the table values are read just fine. However if I use a larger table (~30 MB), I wait for a while and then I get the message: DBD::mysql::st execute failed: Lost connection to MySQL server during query I have tried searching for the solution to this problem and haven't found anything that helps yet. I have changed the values of 'max_allowed_packet' and 'wait_timeout', with no effect. Any ideas?
View Replies !
|
TRACKER
