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 Complete Forum Thread with Replies
Related Forum Messages:
HOWTO Move Users Privs/Grants From One Host To New Host?
converted Oracle DBA to MySQL. I don't seam to find a simple way to move users from one host to a new host. In oracle I would export an user and ALL it's privs/grants and tables and data will be impoted - how do I do this in MySQL - I can sqldump the databases - BUT I would like to move ie PRODUCTION users into a QA database and I want all the structure of Privs, grants and hostname for each users to follow with me - how do I do this? As I see it I have to 'manually' pre-create all the users priv and grants on the new QA host .... Is there a command line tool who would do this for me?
View Replies !
Local Host Vs ISP Host Name In Connect Command
I'm having a problem figuring out how to configure my Connect command so I can test on my PC and upload scripts to my ISP without constantly changing the Connect command to reflect the applicable host. I use LocalHost on my machine and then change it to my ISP's IP on their network before uploading the scripts. I'm sure there's something I'm missing in the manual about setting up Grants.
View Replies !
DB Move From Host To Host Truncated
I'm moving my wordpress site from one host to another and I exported the schema and data from MySQL to a .SQL file and then imported it to my new host. Everything seemed to go okay, but all of the posts are being truncated after the first paragraph or so. I looked in the sql file and the whole post seems to be there. Anyone have a clue what I'm doing wrong? I'm using myphpadmin to do this.
View Replies !
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 !
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 !
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 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 !
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 !
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 !
Web Host
Does anybody know any web hosting companies that are currently supporting mysql 4.1 alpha? How is one able to utilize the subqueries feature found in mysql 4.1 when nobody seems to support it. Running my own server is currently not an option.
View Replies !
IP Host
How can I make MySQL to host on my real IP not on localhost? Do I have to install a program or something else?
View Replies !
Host Restrictions
However,After tightly integrating PHP/MySql into my website I come across several issues. I've just come to find out that the hosting firm runs their PHP in Safe Mode with several restrictions and quite a bit of lost functionality. The link I provided above shows their safe mode restrictions. What I would like to know is that if this is common for hosting firms. The problem I am having now is that I cannot get the Header function to work and I can't get any cookie sessions going. The code is absolutely good. It works on LAN testing. Take a look at the link and tell me what you think. Is their another hosting firm that has less restrictions that you know of or is this common.
View Replies !
Connection To The Host
I'm a comeplete MySQL noob, I can't seem to connect to MySQL through telnet. I don't know why I can't connect. BTW, the white boxes are covering my IP.
View Replies !
Host Blocked
i dunoe how to unlock tis thing .... Discuz! info: Can not connect to MySQL server Time: 2004-12-4 2:42pm Script: /index.php Error: Host '192.168.11.2' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' Errno.: 1129 Similar error report has beed dispatched to administrator before.
View Replies !
Host Not Allowed
So, my problem is: Host >compname< is not allowed to connect to this MYSQL server It comes when Im trying to connect to the server. Do any1 know how I fix it?
View Replies !
Host Address
is there a variable in mysql that stores the host address or ip of the remote machine issuing the command?I want records to contain the ip or hostname of the remote machines.i know how to do this in php, but i want this in pure mysql if possible.
View Replies !
Change The Host
i use "localhost" as host in MySQL i want change to my ip but give a error when change! (something about permisions) what the right way to do?
View Replies !
Old MySql -> New Host
I am currently in the process of moving a mysql database on my old server to a new host. But I am running into a problem. The old host I had was using mysql 4.1 on their server and the new host has 4.0. It didnt seem like a problem at first but now when I try to import the database even in 4.0 compatibility mode when I exported it, it wont work. Is it not backwards compatible or something?
View Replies !
Err 1130 Host
want to test drive Moodle open source course managemnt system (CMS) I downloaded xampp (apache, mysql, etc) I'm tying to run home PC as server so I can test drive Moodle CMS I downloaded MySQL-Front panel so I could set up DB for CMS When I try to run sql panel I get err 1130 host not allowed to connect to server I'm old mainframe jock and have no experience or training w/mysql or apache or server set up, but figure there is some config setting I need to make
View Replies !
5.0.55 Security And Host Over The Net
This is my first posting so I'll just take a quick moment to say 'Hi', and annouce that Im a MySql & Perl lover and wish you all good luck with whatever it is your doing. And now .. :D Ive only been using (well, playing) with MySql for a couple of months so Im not exactly a grand master with it yet. Unfortunately security isnt one of my strong points and Ive essentially opened a MySql database to the net and wondered if anyone knows of any vulnerabilies. It's hosted on a Solaris 10 system, mysql & telnet ports are open to the net. In both unix and mysql, the 'root' and 'mysql' user's have strong passwords and everything's pretty much tied down as you'd expect it to be. On mysql, the root and mysql user id's have strong passwords - and Ive used MySql Administrator to create a 'guest' login (which a weak password) which ive only grantd the "SELECT" function to for one schema. I cant find a way to make updates work with this 'guest' user, but it is able to use 'Select' queries against any schema in the database and you can use MySql Administrator and login as the guest user to get system info. But you can't edit user accounts (phew!). So, while there doesnt seem to be an easy way in to a MySql database open to the net, it doesnt exactly feel or look very secure. Is there anything I can do to make it more secure? (Mysql & Root logins are only allowed from the hosting machine) - this 'guest' account is the only one that can login over the net.
View Replies !
Add Host To Permissions
Typically, one does something like "grant x,y,z on db.* to user1@localhost identified by 'password'". Is there a good way to clone the permissions for "user1@trusted-host1" et al? Particularly sometime later when one doesn't remember exactly what "x", "y" and "z" were exactly? I can look at the bazillion settings already there, but it's rather a pain to count exactly how many '"",''s and '"y",''s have to be where in the insert and what I really want is to just clone the entry, changing one field...
View Replies !
Not Able To Connect From Any Host
when I try to connect to it from any machine (including the machine running the MSQL server itself), it says "server 'xxxxx' is not allowed to connect to this mysql server". Can any one help me how can I remove this error, and connect to the server? If there is any change required in the database, the first thing to perform the change is to connect the database, but since I am unable to connect from any user and any machine,
View Replies !
Host Mysql,
I have bought some webhosting and they only allow me to have 1 sql database. Now i thought maybe i could host a mysql database myself. and just set it up so that it access my own mysql server. Is this possible? what ports need to be open and do i have to create a user in a special way? is there a how to on this?
View Replies !
Changing Host Name
Mysqld is configured and running, And my question is, If i change my host name how mysql is affected, which tables are affected, etc?
View Replies !
Host For Target DB?
I am going to convert my access db tp MySQL. But the program asks for Host, Port, Username and Password. Since I am just starting PHP and re-doing this web site in PHP; what do I answer?
View Replies !
Help My Host Is Killing Me With This.
Ok, so I use Joomla! as my content manager system under the database itt_admin and I use SMF as my Forum under the database itt_forum. What I need to do is have it so that when users register on my Joomla! website it will automatically add that user to the SMF Forum website and vis versa. I normally would do this in cPanel by simply going to MySQL and going to the drop down menu and selecting user and then the other drop down menu and selecting my database and then clicking "add user to db" however, my Host does not offer cPanel. Sympliy I am only able view each individual MySQL database in phpmyadmin. So, my question is how do I bridge these two databases so it has the same effect as it would have if I had used that option with cPanel?
View Replies !
Connecting To A DB On A Different Host
Say, I have 2 shared hosting account. Hosting A(www.aaa.com / 202.111.111.11) and Hosting B(www.bbb.com/202.222.222.22). How do I connect to a dbase in Hosting B from Hosting A? Say my access host in Hosting B is called "localhost" by default. I am using PHP to do the connection. mysqli_connect("accesshost", "username", "password", "dbname"); What do I specify for "accesshost" in the mysqli_connect?
View Replies !
Remote Host Connectivity
I just started using MySQL, and cannot find how to configure host access in the my.cnf file. I want to be able to allow access to a MySQL database from a remote host, and also from a particular network. How do you configure access of this sort?
View Replies !
User That Can Connect From Any Host?
It seems to have to add a user to the mysql.users table for each HOST they want to connect from. Well, we have a few users (admins) who access the company DB from home and they have dynamic IP addresses (dialup or DSL.) Is there any way to add a user once to the DB who will be able to connect from ANYWHERE. I've tried * or a blank entry for the HOST field, to no avail. Or can a ip range, like 123.124.125.* or 123.124.*.* be some how entered?
View Replies !
Host Is Not Allowed To Connect
I have mysql working. I have change my hostname name(until now i used localhost) and i cannot connect. # mysql -u mail -p -h server.domain.com Enter password: ERROR 1130: Host '196.26.0.3' is not allowed to connect to this MySQL server # mysqladmin -u root -h server.domain.com -p password 'pass' Enter password: mysqladmin: connect to server at 'server.domain.com' failed error: 'Host '196.26.0.3' is not allowed to connect to this MySQL server'
View Replies !
Finding Mysql Host
i'm did a site for a client involving perl & mysql. (i used phpmyadmin to work with mysql back on my server) now i need to create everthing on the client's web-site.. and all i know from the client is the domain name (andregaron.com) database name db usrname db password how do find out the host? and where do login to create into mysql to create new tables?
View Replies !
Host 'localhost' Is Not Allowed
I'm setting up a server for a client and I get this error "Host 'localhost' is not allowed to connect to this MySQL server" whenever I try running a script that talks to MySQL. I used PHPadmin to access the mysql.user table and change the passwords for both root accounts (localhost and any host). I don't know what exactly caused this but I need to fix it.
View Replies !
MySQL 2k+ Storage Host
A good MySQL host? i just need access to a MySQL database. I need to be able to connect to it from another website/server. i dont care if it is pay or not just as long as it isnt too much and doesnt have a "max_questions" limit set i have a huge database with 2K+ entries, and freesql.org only allows 1600 "max_questions".
View Replies !
Replication :: Host Should Not Be An IP Address
the host should not be an IP address. I even checked the hostname of the machine and it is correct. I tried adding the correct host name to the username when connecting. Still get the same error. I even tried granting replication to 'repl'@'%' for all hosts and it still givess access denied to 'repl' @'10.68.0.1' tried granting replication to 'root'@'10.68.0.1' and it still gives me access denied. Tried grant all to 'repl'@'%' and 'repl'@'10.68.0.1' and it still gives me ACCESS DENIED. I did flush privileges after each grant statement.
View Replies !
Setting MySQL Host
I'm looking to grant access to a MySQL database based on a range of IPs. I did a search on the forums here and couldn't find exactly what I was looking for. The IP range is actually only 2 IP addresses but I'm sure there must be a way of setting the Host to accept something like: 123.123.123.*.Currently I can't test it as I don't have access to the web servers, but it someone could tell me the surefire way of doing this it will be one less worry for me .
View Replies !
Setting Up Local Host.
Not sure if this is in the right area, so please move it if not. i have downloaded xampp , and it is the first time i am trying to set up a local host on my computer. P.S: I am no where close to being a programmer I installed it correctly so that wen i run http://localhost , the xampp front page opens, and says mysql, php, etc. etc. are installed. Now i need to know what to do next so that i can configure phpBB to work with it on my localhost.
View Replies !
Host Permission Denied
I have installed php and mysql on my machine at home and at work. I have done exactly the same for both but the one at home denies permission to my localhost where as the one at work works fine, connecting to my database from php and importing the info. At home both php and mysql work fine independently, I have set up username and passwords and granted total privileges to the user but I still cannot get it to connect. The only difference is I have a imac g5 at home where at work it is a power Mac, would this make a difference?
View Replies !
Backup/Restore To Web Host
I'm migrating a web site from my testing system on my local machine to the web host upon which it will live. My testing server is running MySQL v. 5.0.22, and the remote host is running 4.0.24. I am using MySQL Administrator v. 1.0.10 to run a backup and export my tables to an SQL file, and PHPMyAdmin to import the SQL file and run it on the server. At first, I was getting a 1065 - Query is Empty error. After reading through some of the postings here, I realized that some of the commented strings at the top of the file were unnecessary, and probably the cause of my error, so I removed them. I re-ran a backup that would only backup the appropriate tables and write the appropriate data (the database schema on my server is named differently, so I don't need to back up the full path). After editing the file to remove the uneeded stuff, I recieve a different error message, regarding an error in the SQL syntax of the dump file. The error in question occurs on a line that reads as follows: )ENGINE = MYIASM DEFAULT CHARSET = latin1; The error in question is as follows: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 21 I'm having a hard time finding the issue, and would really appreciate if somebody might point me in the right direction to help me create a backup file that my server will interpret charitably and restore the data I need. I'm getting to the point where I may have to re-enter it all by hand, and that thought depresses me quite thoroughly.
View Replies !
Moving A My SQL Database To A Different Host
I have a number of databases and 3 hosts I am currenlty using. One of the hosts has too much down time and I would like to migrate the database before I address issues with him. I want to get the full structure and content across to my new host which had a much better time on line. I am using cpanel for access on the new one and Myadmin on the other both have my SQL and php running the interfaces look virtually identical from this persepctive. If I download from one and upload to the other should I just do a simple download upload operation or do I need to install the database in some way first. The help I've seen talks about command line access but the interface on each is a bit more WYSIWIG than command line so using the tutorial is proving to be interesting.
View Replies !
|
TRACKER
