Testing Access To MySQL-DB In Windows-Network
Background: I am writing in C# a program, which reads data out of a MySQL-DB. When the DB is on my local developer PC everything is fine. But when trying to access the MySQL-DB on a server in our Windowsnetwork, I receive the message: "Host '**' is not allowed to connect to this MySQL server".
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Unable To Access Mysql On Network
We have one PC running xampp with a website on. that's working fine. however, when we go to another computer on the network and try to access the site, it cannot connect to mysql. eg: 192.168.5.101 is the machine running the site. (everything works fine) when accessing 192.168.5.101/site/ from another machine, the static HTML pages come over fine, but when we try to access a page using a mysql connection (PHP) we get an error. Access denied for user ODBC@localhost. the PHP method we use to connect is mysql_connect("localhost","root","")
Error 13, Access A File In The Network
i am actually accessing a file that is located in the network, i get error 13 permission denied. It seems that i only can access files in a local disk drive. How can i set mysql to access the network??
MySQL 3.23 Windows Access
I am trying to set up an Invision Board forum on my windows 2003 RC2 server. I have already set up and configured PHP4. I am now in the process of setting up mySQL. I have never used it, so you can imagine how confused I feel right now. I installed the 3.23 windows version on C:mySQL I do not know how to access it, nor really how to use it. The invision board is asking me to input SQL Database Name SQL Username SQL Password How do I createaccess this information. Thank you for your help. BTW: I recive this error while attempting to connect to my sql via cmd.exe "ERROR 2003: Cant connect to my SQL server on Local Host (10061)" I have two firewalls, XP's built in one and Norton Internet Security. Could this be the reason.
How Do I Setup The Server On A Network Drive For Client Software To Access?
I'm building a database system for our department at work and have successfully installed the MySQL Server 5.0 to my local machine and developed my user interface to access it read/write/update, etc. just fine through VB6 and the ODBC driver. My problem now is how do I get the database files and server functions moved/transplanted/installed on a network share drive (Windows 2000) that my peers and I have access to, so that I can deploy me client user interface onto their machines so we can all access the database across the network and I can get the files off my local hard drive?
How Can I Access Mysql Database Running On Windows Pc
How can i access mysql database running on windows pc from linux server, on both machine i am using mysql 5 and perl 5.8.8 , ip of windows machine ie. 192.168.0.50 and linux server has 192.168.0.10 on single LAN.
Access Denied During Windows Installation
I'm using the MySQL Server Instance Configuration Wizard to configure the MySQL server 4.1 and I'm getting the following error after attempting to modify my security settings: Error Number 1045 Access denied fo user 'root'@'localhost'(using password:NO) I've tried uninstalling and reinstalling but it keeps coming up. I tried playing around with the command line installer and I think that's what may have borked me.
Local Host On Windows Allowing Remote Access
We have MySQL running on a server in the US (we are in NZ) the response times to queries can vary, so i have installed MySQL on my Windows XP PC. i can transfer data across overnight using a scheduled task, this allows me to query yesterdays data much quicker - it is used for trends so up to date in not important - the problem i have is this I want others within the company to be able to connect to my PC to run their own queries against my data. i do not know how to set up the ODBC connections on their PCs to 'talk' to mine. I can set them up to connect to the US with no problem but not to my PC.
Testing MySQL
I'm trying to test MySQL (i've already tested php and it works, so I'm not real sure I need this step, but I'm sure I need to know how to do it reagardless). I test it using localhost as the hostname and it works except that this is what the page looks like. ....
MySQL Testing
I just recently installed MySQL and am also running an APACHE 2.0 server on my computer (Windows XP machine). I followed the instructions in the help document on installing MySQL and I believe it is installed properly, no errors occured, it was pretty straight forward. However, when it comes to testing, the documentations on give commands using the "Windows Command Line Client" and not the MySQL Command Line Client. I installed MySQL as a service, that turns on and off with Windows.
Testing SSL Conections W/ MYSQL
I recently installed all MySQL 4.1.1 including max RPMS. During the installation i used "--nodeps" on MAX package and at Shared-compat cause they were requiring the libssl.0.9.6 and libcrypto.0.9.6. I am using a RH 9 and these files are installed on my system. The result for mysql query : show variables like 'have_openssl'; is have_openssl | YES I created a user using the grant command with 'require ssl' like this: [color=blue] > grant insert,select on MyDatabase.* to myssluser@myhost require ssl;[/color] Query OK I can connect using this username and CLIENT_SSL param (isn't this param just for php 4.3 or higher?): mysql_connect($dbserver, "myssluser", $dbpass, CLIENT_SSL); It runs on my php 4.2.2 compiled with openssl 0.9.7, but i need to TEST if this is a real ssl connection.
Load Testing MySQL
I know this is quite a bit off topic, but i was wondering if anyone else out there had any experience with Segue's Silk Performer load testing tools. More specifically, i am trying to compile a test script to allow me to perform some transactional database testing to load test a MySQL 4.0.13 database server running behind some apache webservers. I have obtained an ODBC driver from MySQL and have some specific queries i would like to use in the test. I am have used SP to load test the webservers specifically, but i am not 100% sure how to run this against a database server now. If anyone has any experience they can share, please feel free to email me off list.
MySQL Over A Network
I'm trying to connect to a MySQL database from one computer on a network to another computer on the same network.
Installing PHP/MYSQL On A Win Network
I am going to teach PHP/MYSQL to a group of students on a windows network. Do I have to install these on every station or only on the server? In which directory do the students save and test their work?
MySQL And Network Appliance
I was reading about The DataWare 2600 appliance from PogoLinux but that device was made back in 2003. I have a client server application that gathers computer information and uses that info in a database to deploy new pc's. Today I use Microsoft SQL 2005 database. It would be nice if I could use a Network Appliance running MySQL and Linux embedded rather that a traditional Microsoft server with SQL 2005. Are there any network appliance products available today that run MySQL with Linux embedded. I searched the web and couldn't find any vendors that offer this solution. Is there anything like this out in the market? My next question is how hard would it be to convert the database and queries from Microsoft SQL 2005 to MySQL?
Network Traffic MySQL 4.1
Is anybody familar with the status variable "bytes_sent"? I have been running MySQL 4.0 on a Windows 2000 server for over a year and the variable "bytes_sent" was never greater than 0. Which would make sense because I am using MySQL for a in-house application that is networked throughout the plant. It is my understanding that bytes_sent is bytes sent through a TCP/IP connection. Anyways, I just installed MySQL 4.1 on a PC for testing and the "bytes_sent" field is jumping like crazy and I am the only user logged into the database. Where are the bytes being sent to?
Mysql On Local Network
Is there a way to share mysql on a local network? Both computers running IIS on Windows XP Pro. Both have php running, but using a root website folder on another computer (main server). Both are running PhpMyAdmin, but we are getting our own MySql database showing up. I want us both to get access to one MySql server. We both access the website using http://localhost
MySQL On A Network Drive Error
I want to install the current version 4.0.13 of MySQL on a Win2000 machine in a directory different to the default (C:mysql). It should be a network drive, as this is backed up by our IT staff. I install the package using setup.exe and selecting "Custom" but just clicking OK on the following dialogue. As directory I selected something like "H:....MySQL_4.0.13". The package is installed correctly. I can install the service (mysqld --install) and see it in the Service catalogue of Win2K. However, when I want to run the service with "net start mysql" an error occurs: System error 65 has occured. Network access is denied. I checked the security settings on the directories, but I had the change priviledges. Setting them to "full access" didn't improve the situation. MySQL only works when I install it entirely on C:. What am I missing here? I would like the installation to reside on a network drive for the reasons outlined above.
MySql Replication And Network Speed
We purchased 2 new HP DL385 servers that will be used for MySQL 5 in a replication environment. Server 1 (Master) is connected gigabit to our Cisco 3550 core switch The Cisco 3550 core switch is connected gigabit over fiber to a Cisco 3548 switch in another building. Server 2 (Slave) is connected to the Cisco 3548 on a 100MB switched port. My question is whether or not the 100MB connection is going to be good enough to do replication, or if I have to invest in getting gigabit all the way to the slave server?
Unable To Connect MySQL Server Across The Network
We have a MySQL server that was managed by another group in our company, the guy who used to manage that MySQL server has promptly left. Now this server has turned into me. I'm a Microsoft SQL guy, however, the manager doesn't think there is much difference between MSSQL and MYSQL. Now I am in the hot seat to fix a problem that just occurred last week. We're suddenly not able to connect this MySQL server across the network. I checked the network connection, everything looked fine, I was able to telnet into the port 3306. First I thought someone changed the root password, but I was able to connect the server from the local server by using: mysql -h localhost -u root -p Other accounts have the same problem as well. If I try to connect this MySQL server from a workstation, I'll get the following error message: ERROR 1045 (00000): Access denied for user: 'root@CS7LL11' (Using password: YES) It will be geatly appreciated if someone can inform me what I need to do to fix this problem. By the way, this MySQL server has the version # 3.32.56-nt
MySQL Data On A Mapped Network Drive
I would like to have MySQL use a mapped network drive. I'd like to do this in case there is a failure of the mysql machine, I can just replace it with a new machine pointing to the same network drive.
Testing For Bit Set In Int Field
Say I have a column of type int(4) and it represents a bitmapped pattern, so bit pos 1 means "apples", 2 means "oranges", 3 means pears etc. The value 3 is "apples & oranges". How would I construct a query such that I could return these? For example, if I was searching for oranges and the bitmap field was called type in table fruit the logic would be SELECT FROM fruit WHERE (type & 0x02) > 0; All my tests so far just return all values.
DB Testing Software
Are there any available tools for testing mysql db performance? What do you guys typically use for testing your db's performance and data integrity?
How Do I Set Up My System As A Testing Server
I work on a Windows XP Pro. Platform and I am having trouble setting my system up as a Testing Server for PHP pages. I want to be able to test scripts and build my database. I tried downloading and installing MYSQL and PHP but it still does not work. Is there some kind of Configuration I need to do in the PHP.ini file?
Load Testing Tools
We are developing an application using PHP and MySQL 4.0.16, that we need to stress test. Can someone please point me to some testing tools we can use?
Equality Testing With NULLs?
When I do "SELECT count(1) FROM table_name WHERE 0 <> 2", I get the total number of rows in the table. When I do "SELECT count(1) FROM table_name WHERE NULL <> 2", I get 0. Shouldn't I the same answer as I did with WHERE 0 <> 2?
Load Testing Tools
We are developing an application using PHP and MySQL 4.0.16, that we need to stress test. Can someone please point me to some testing tools we can use?
Testing On Update & Delete Cascade
When I added indexes and foreign keys to my tables I also inserted ON UPDATE CASCADE and ON DELETE CASCADE. However, when I tried testing that this works by entering:- select * from address, name where address.name_ID=name.ID; It says empty set. What am I doing wrong?
Testing Speed And Query Cache
I'm trying to test performance on some queries with a million of registers on my table, using various keys. The problem is that the first time i run the query, it takes about 4/5 seconds, but after that it takes about 0.02 seconds. I know that query cache can be flushed with reset query cache, flush query cache, flush tables also modifing some caps at the sql query, but i'll never take 4/5 seconds again. for example: select * from table where id=2 order by index_field desc; 4/5 seconds. select * from table where id=2 order by index_field desc; 0.02 seconds. select * from table where id=3 order by index_field desc; 4/5 seconds. select * from table where id=3 order by index_field desc; 0.02 seconds. etc, etc...
Testing On Update & Delete Cascade
When I added indexes and foreign keys to my tables I also inserted ON UPDATE CASCADE and ON DELETE CASCADE. However, when I tried testing that this works by entering:- select * from address, name where address.name_ID=name.ID; It says empty set. What am I doing wrong?
Testing Parameters Within A SELECT Statement
I am building a SELECT statement where I will be passed search parameters depending on what user has entered. Each parameter may have a value or maybe NULL. What construct (CASE, IF, etc) can I use to build my WHERE clause so that the passed value is included or if NULL, all rows are returned. SELECT * FROM table WHERE col_a = val_a (or if VAL is NULL then all rows) AND col_b = val_b (or if VAL is NULL then all rows) AND col_c = val_c (or if VAL is NULL then all rows) etc ...
Bogus Datasets For Database Testing
I'm teaching myself mysql and wonder if there are any sources of inane, complex, bogus data that I can download and insert into a table(s.) I have created some very small sets to practice joins and whatnot but they are not very big or complex, or exciting. compressed tar of text strings (no blobs) could have plenty of data but still be a manageable download. It would also be a nice test of my machine and tuning skills.
ERROR 1045 When Testing In The Control Center
In the MySQL Control Center 0.9.4-beta, I right click the top level server name and choose the Edit option. Then I have entered a User Name and a Password in the General TAB. I then mark the option "Promt for Password" and hit the "Test" button. I get a small window where I should enter the password for User name@Host name. I enter the password and hit the OK button. Now I get the error message "ERROR 1045; Access denied for user; 'User name@Host name' (Using password: YES)" When looking in the Help menu, the Contents - F1 is not activated, so I can't get any online help. I'm just wondering why the test for the password failed and why there are no online help in the consol?
Testing The Database? Backing Up, General Checks
I want to know what else I can be doing to check the stability of our database. Currently what I do every evening is download the complete database through PHPMyAdmin on our dedicated server, once downloaded I start up the Wamp Server and import the database locally through PHPMyAdmin on my own machine. The next thing I do is run the Check Tables command on all the tables to see if everything is where it is. It always comes back as OK on each table so I presume everything is ok? Is there anything else I should be doing, or is what I am doing correct? Every so often we delete auctions to free up space in the database. Once this is done we have overhead in the tables. Sometimes this can be 2-10mb, so what I do then is run the optimise command on the tables, again am I correct in doing this? Finally our database is now over 40mb, to me this massive as the largest database I have worked on before has been 4mb, please dont laugh. What sort of database sizes have you seen in MySql or are you running at present? What is MySql like in the long run stability wise. If looked after can we get many years of good service from it.
Testing For An Empty Set Returned By A Nested Select Statement
For those of you following the "While Loop Within Select" thread... I've been restructuring my database to incorporate the changes. Now I've got a table of skipped stops rather than a table of stops (I need it that way for various reasons) and I need to return the schedule to the user as long as the user's stop isn't in the list of skipped stops. SO say something like: SELECT yada yada yada FROM schedule AS 's1' WHERE ( SELECT skippedstop_id FROM skippedstops WHERE schedule_id=s1.schedule_id AND location_id=$origin ) == "EMPTY SET" Only I have no idea how to actually test for the empty set from the nested select...
Network
Using a trigger can I send a TCP/IP message to the network everytime a new record is INSERT into a table?
Can't Connect Over Network
I have mysql 4.0.16 on my windows machine and have just installed suse linux on another machine. It comes with mysql 4.0.15. After I got the user setup I was able to use the mysql client on the windows machine to connect to mysql on the linux machine I even used mysqldump piped to mysql to dump a database to the new server. But now I can't seem to login anymore. I don't think I changed any settings on the linux machine so I am at a loss as to why I am getting this error. ERROR 2013: Lost connection to MySQL server during query That happens immediately after I type in mysql -h 192.168.1.2 -u cdw -pxxxxxx and hit enter
Can't Connect Over Network
I have mysql 4.0.16 on my windows machine and have just installed suse linux on another machine. It comes with mysql 4.0.15. After I got the user setup I was able to use the mysql client on the windows machine to connect to mysql on the linux machine I even used mysqldump piped to mysql to dump a database to the new server. But now I can't seem to login anymore. I don't think I changed any settings on the linux machine so I am at a loss as to why I am getting this error. ERROR 2013: Lost connection to MySQL server during query That happens immediately after I type in mysql -h 192.168.1.2 -u cdw -pxxxxxx and hit enter.
Network Connections
I can connect to the database on my FreeBSD system, but not from another system on my network. How do I set it up to allow remote connections?
Connectivity Across The Network
I have read many postings about limiting connectivity and security. I would simply like to be able to connect my jdbc java applet to my mysql database. I can connect when I run the browser from the same machine as both the web server and mysql db and then set jdbc driver code for URL to 'localhost' or '127.0.0.1' and everything seems to work fine. COnnects, applet works, I can read and write data, etc. But when I set the JDBC code URL to '192.168.1.3' (the IP address of my machine) and try to access this, I cannot connect to the database at all from any machine. How do I allow connections to mysql from something that is not localhost or is on another machine?
Connecting To Database Over Network
I have a couple computers under one domain. I installed a MySQL database on my secondary computer and want to be able to access the information from that database on my primary computer. Both computers are able to share files, no problem there, but when I try to connect to my secondary computer from my primary, it times out and says "Can't connect to mysql server on 'second computer';" I had this working before but for some reason I can't get it to work now. Any ideas of what I'm missing here? Also I'm using MySQLcc so it makes it a little easier for me. I've even created a second user account for the MySQL database on my secondary computer so I'm not trying to connect to through the root user. (For example purpose, my secondary is called second and primary is call first...) From my primary computer, I try to connect using this.. Hostname: second User: user1 password: **** And it times out when I try this. If I put this into my secondary computer it connects no problem.
Logging On From Network Workstation
Having trouble logging on to the server from a workstaion on the network. Have added myself as a global user and the workstation as a host. MySql is listening on port 3306 but I can't make a connection. I get [bob@Comp1 bob]$ mysql -h 192.168.0.2 -u bob -p Enter password: ERROR 1045: Access denied for user: 'bob@Comp1.home.wtaustralia.com' (Using password: YES) I am using Mandrake10.0 and Mysql 4.0.18 I can connect using ssh but not as a remote user.
Administrator And Network Names
I recently unchecked "Disable name resolving" within administrator, located on network server. My boss and I are the only administrators on the system and after a server reboot, our network names were resolved in administrator. However every other computer on the network, without mysql administrator, still appears as "localhost:port#. Is there a way to see other network names?
Can't Connect Over Local Network
I have installed MySQL on 2 machines on my network, on an XP machine and on an eMac. Using CocoaMySQL on the emac I can connect to data on the XP machine. But when I try to connect to data on the eMac using MySQL Control Center on the XP machine, I get this alert popping up: Critical ERROR 1130: Host '10.0.1.2' is not allowed to connect to this MySQL serve (sic) So, the error on the XP box says that the XP box is a host not allowed to connect to "this" presumable what I had entered as the IP of the eMac (10.0.1.3).
|
TRACKER
