Accessing Mysql From Another Host
New install of mysql on Solaris 10 x86.
I cannot connect from any other host, lots of traffic on google with people with the same error. Talk of the grant command fixing this, but no details. So simple question.
What "exactly" do I type to allow connections to port 3306 from another host to avoid messages such as
ERROR 1130 (00000): Host 'am-ms-t.foo.baa' is not allowed to connect to this MySQL server
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 !
Accessing Dev.mysql.com
I'm trying to download MySQL4.1 from the MySQL site and when I try and go to the download section on the site it either fails or, if it loads, the "pick a mirror site" links always fail. By "fail" I mean that it doesn't manage to retrieve the requested page, either sticking on "waiting for dev.mysql.com" or "connecting to dev.mysql.com" in the status line of the browser, eventually giving up with an "operation timed out" error message. Is anyone else having this problem or is it just me? - this has been ongoing for the past couple of days now. Incidentally, I need a version of MySQL that can handle subqueries yet I'm still using glibc-2.2.5-40 and Redhat 7.3 (upgrading simply isn't an option right now) - can anyone suggest a stable sub-version of 4.1 that fits this criteria?
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 !
Accessing MySql On Yahoo
I have never used MySql before.I program in C# and Visual FoxPro against MS SQL on a corporate network. I have a Yahoo web page, and I'm going to use their MySQL DB. I want to run queries, Inserts, Updates and Deletes. I have no idea how to connect to MySql on Yahoo from a client like C# or VFP.
View Replies !
Accessing MySQL Database.
I have recently installed MySQL 5.0.27 / PHP 5.2.0 / Apache 2.2.3 on an XP os. I created an empty database via the MySQL command line which is visible when I type SHOW DATABASES at the mysql prompt. I have changed my root password which works OK. I set up the password to the empty db by: GRANT ALL ON database name.* TO username@localhost IDENTIFIED BY 'password' To access the db, when I type : mysql -D dbname -u username -p I do not get a prompt to enter the password.
View Replies !
Accessing MySQL Data
This morning when I tried to access my MySQL installation through MySQL Query Browser, all schemas have a message stating "Fecthing Data..." when I expand the schema. If I access MySQL through the command line, I get the following message when I execute a "use" command: "Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A" If I execute mysql using "-A", then it appears I can access the data, but it's very slow. Has anyone experienced this and if so, do you know how to resolve it?
View Replies !
Accessing Mysql Server On LAN
I have a problem accessing mysql server on my LAN: i can access it locally but not from other machine. The error is: Lost connection to mysql server during query. I've disabled the firewall but it's still not working. What i don't know is if i set the users correctly...
View Replies !
Accessing A Mysql DB Remotely
I am building a kiosk which uses a lockdown browser. The browser uses a php page to access a MySQL DB on a web server. It will not allow me to connect to the DB because I am using the following connection string: mysql_connect("localhost","*****","*****"); mysql_select_db("******") or die ('I cannot connect to the database because: ' . mysql_error()); I know that the problem here is that I'm trying to connect to 'localhost' when the actual DB resides elsewhere. The question I'm asking is how to find out how to connect to my DB. Is it just mysql.mydomain.com instead of localhost or what?
View Replies !
Error 1130 When Accessing MySQL From Another IP??
I am trying to run the MySQL DB on a Linux machine that is part of a home LAN (IP=192.168.0.3), while trying to access it from another WinXP machine (IP=192.168.0.5). I keep getting the following error: MySQL Error Number 1130 #HY000Host '192.168.0.5' is not allowed to this MySQL server Ping works fine. On searching the internet, I find reference to "allow list" hidden somewhere in the guts of MySQL. Can anyone provide me hints on how to add to this list?
View Replies !
Accessing Mysql After Fresh Installation
I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After installing when enter into mysql it gives me message " Access denied for user root@local host .......using password yes" i have tried all the options like #mysql -u root -h localhost #mysql -u root -h localhost -p #mysql -u root -h localhost -p mysql #mysql -u root -h localhost test -p #mysql -u root -h localhost test #mysql -u root #mysql -u root mysql but none of the option is working at all. Please any idea how i can change the root password or enter the mysql after fresh installation.
View Replies !
Accessing Mysql Database From Php File
I can access mysql in dos with the command of c:mysqlinmysql -u root mysql but when i write the command of mysql_connect ("localhost", "username", "password") i don't know what my username or password is. I have installed Apache to run the mysql database and php on my computer although I don't know where to find out the username and password so if someone could help that would be great.
View Replies !
Accessing Mysql From Command Prompt
The path to my mysql installation is "C:Program Filesxamppmysqlin". I want to run myisamchk - to do this I think I have to access it via the command prompt. A stupid question - I kmow - but how do I get to the directory in a DOS window??
View Replies !
Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...
View Replies !
Accessing Remote MySQL Database
Is it possible to access remote MySQL databases? I manage several sites and I will soon be building a tool that can track all of them, and it would be really convenient if I could somehow access all of the databases from one remote site.
View Replies !
Accessing MySQL BLOB Columns Using Visual C#
I am trying to write an image file to a remote MySQL Database. The following code show the section I try to save the ImageArragy into the MySQL BLOB column. The error that I am getting is : Can someone tell me where I am going wrong and how I can fix this problem?
View Replies !
Accessing Data On An SQL-Server By Using MySQL-Select
is it possible to access data located in a SQL-Server-Database by using a MySQL SELECT-Statement? I know that on an I can use a qurey like the following SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:Financeaccount.xls";User ID=Admin;Password=;Extended properties=Excel 5.0') on an MS-SQL-Server and search for something similar in MySQL.
View Replies !
Accessing A Mysql Database On A Remote Server
i would like to know how to connect to a remote mysql server which is on linux from a windows system. I gave the command: mysql -u root -p redhat -h 192.168.1.132, where the ip is the ip of the linux server. But i got the error message stating that :- Host 192.168.1.114(which is my system ip) is not allowed to connect to this MySQL server.Sreejith
View Replies !
Accessing MySql Thru Coldfusion - Password Problem
I have downloaded MySql 5.0 for Windows (XP) and MySqlCC so I can interact with it. When I installed MySQl I created a username and password which I can see in "my ini" file. I don't remember creating any passwords through mysqlcc. I am building a database driven website using "macromedia studio MX" and am experiencing problems accessing my Mysql database through that software - I keep getting asked for a login ID and password, and for the life of me, have no idea what they are. 1. When I originally added my database as a 'data source' in Cold Fusion (MX 6.1 administrator) it would not let me create a password. I kept getting error messages like "The root cause was that: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'martin'@'localhost' (Using password: YES)" etc etc etc variations on that theme. (adding the database without a password wasn't a problem) 2. Now I am trying to create a dynamic page in Dreamweaver (using Coldfusion) to display my data – there is a 6 point process in the ‘server behaviors’ tab and I’m up to the last one “press the (+) plus button and choose ‘Recordset (Query). WHEN I SELECT MY DATABASE AS A DATA SOURCE IT ASKS ME FOR A "LOGIN ID" AND "PASSWORD." I've tried all the passwords I can think of that I used and nothing works, the error message I get is: "-1:Syntax error or access violation: 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 'wine like '%' at line 1. this is then followed by about 27 lines of commands like "at org.gjt.mm.mysql..".bladedblahdeblah " (I am creating a database of wine tasting notes)
View Replies !
Accessing Mysql On Win2003 Server From A Station
I have installed Mysql on a Win2003 server and it is running as a service. I created a database and it works ok on the server logged on as root. I then tried to access the database from a station on the network using PHP code and I get the error - Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in G:InetpubWWWrootIntranetookingacc.php on line 10. Do I need Mysql Client on the station or does it run on the Server by default?
View Replies !
Error Accessing MS Access Table Linked To MySQL
I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked. Code:
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 !
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 !
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 !
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 !
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 !
Can't Connect To Mysql From A Different Host
Here is the discription of the situation: I have running mysql server on my pc. I can connect to mysql on that pc, create databases ect. So the thing is working and everything is OK, but.... The problem is, that I cannot connect to the mysql on my pc from another pc. In the user table I have such user, that can connect from any host and also a user that theoretically can connect from scpecified hosts, but none of them can really do it. It looks like that: >mysqlinmysql -h myhost -u theuser -p enter password: ********** >ERROR 2003: is not allowed to connect to host 'myhost' (10060) or it gives sometimes >ERROR 2013: lost connection during the query..... and I am sure that this syntax is correct, i mean it works on other pc's.
View Replies !
Changing Mysql On New Host
A friend of mine set up a mySql database for me a while ago and i have been maintaining what he built for some time. Due to issues with bandwidth i have had to transfer web hosts. So i need to transfer what i have into the new panal. Sounds easy - as i say im a complete novice and am struggling. My new host have given me new passwords for my mySql database and i have an SQL dump of my old database. I am starting completely from the absolute beginning on the new database and using things for the very first time. What do i do?
View Replies !
Not Able To Take Mysql Backup From Remote Host
trying to take backup on the remote host from my machine. For which I executed the following command mysqldump --opt -h 198.162.110.201 -u root -p --databases bugs > backup.sql Where 198.162.110.201 is my database server. I am getting the following error after executing this script from my machine mysqldump: Got error: 1045: Access denied for user 'root'@'198.162.110.73' (using password: YES) when trying to connect
View Replies !
Foreign Key Mysql.user(host,name)
i have a users table that in a new database and i would like the users to be in the main mysql.user table. Ive done foreign keys between different Innodb databases but this just doesnt create, im thinking the mysql.user is not a innodb table.
View Replies !
Unknown MySQL Server Host
I have a production webApplication running on linux, apache; which most of the time runs fine, except once a while; I receive this warning message: Warning: Unknown MySQL Server Host 'serverName.com' (11) in /usr/local/apache/htdocs/webApplication/db.php on line 12 ...here is my db.php ... <?PHP function dbConn() { $hostname = "servername.com"; $username = "root"; $password = "the_pwd"; $dbname = "mysqldbName"; $dbLink = mysql_connect ($hostname, $username, $password) OR DIE("Unable to connect to database"); mysql_select_db ($dbname) or die("Unable to select database"); return $dbLink; } function dbEnd($dbLink) { mysql_close($dbLink); } ?>
View Replies !
What May Be The Host Address Of Mysql Server
My mysql database resides on the server. I have to connect it by navicat or other conversion tool. But there is some problem of host address. It shows the incorrect host address or port no. It seems that host address is wrong. What may be the host address of mysql server.
View Replies !
Connect To MySQL Database From Another Host
I am trying to connect to MySQL database at on host (DBhost) from another host (PROGRAMhost). While I try to connect to the database at DBhost from DBhost itself the next is working fine for me: mysql_connect("localhost","dbname","dbpassword") Now I am trying to find out what to use instead of localhost? I tried to replace localhost with host's url : port (I tried number of ports) but this is not working (even when I am connecting from DBhost itself). How can I find out what is the proper value to use instead of localhost?
View Replies !
MySQL 100mb+ Storage Host
I can't find any dedicated servers or anything that give a good chunk of mySQL storage space,100mb is all I can find. Does anyone know of any host that offers a good amount of mySQL space?
View Replies !
Can't Connect To MySql Server On Local Host
When I installed MySql on the Windows 2000 Proffessional ,it works fine.But I followed the same installation steps in Windows 2k Advanced Server.It gives me this error "can't connect to MySql server on local host".It says failed to start service . I couldn't find any mysqld.exe file in the processes list of the Task manager window. Please tell me steps to get mysqld.exe file appear on the task manager. Kindly let me know the way to get mysql running.I have the Operating System on E: drive of my computer.
View Replies !
Table 'mysql.host' Doesn't Exist
Working with mySQL 3.23.58 on Linux, I get this error when trying to start mysqld: -------------------- 060716 03:07:21 mysqld started 060716 03:07:21 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist 060716 03:07:21 mysqld ended --------------------- This Linux machine has been working ok for months, and it stopped suddenly. I don't've any idea about how to fix it, and I don't find any '/etc/my.conf' file into this machine. The install directory is '/usr/local/mysql'.
View Replies !
Remote Access To MYSQL Server Host
I am trying to access a mysql database on my old host (I'm doing a CMS migration to something on a different server.) My hosting company doesn't have a CLUE what I'm talking about when I say MYSQL server host (I'm not even sure I do). They keep telling me it's 'localhost'. I can access both dbs through their prospective phpmyadmins. Is there any way I can find out what the host server is? I would just export the db and then import it into the other one, but all attempts at that have failed.
View Replies !
Host 'localhost' Is Not Allowed To Connect To This MySQL Server
My instance of mysql was having an issue with too many people connecting to it at once, so I ran the configuration utility. Now all of a sudden, I cannot connect from anywhere including localhost. I keep getting the message Host 'localhost' is not allowed to connect to this MySQL server no matter what method I try of connecting. What I initially did was edit the user table and replaced the root/localhost with root/% and I'm guessing this was overwritten by the utility somehow. Can someone tell me if there's a way I can edit the user database?
View Replies !
|
TRACKER
