Turning Localhost To A Network Server
I have a small home network with two computers. On my computer I am running MySQL 4.1.21-community as localhost. I have only be using this for development work.
My husband wants to learn SQL so I would like to be able to have Mysql Query Browser installed on his machine, with him accessing all the databases I have set up on my machine.
How do I go about giving him access to my databases?
My machine runs Windows XP and his runs Windows 2000.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
List Server Names On Network.
I want to list all the server names on the network which are connected to my system. I want to proceed this using MYSQL.
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
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?
Moving From Localhost To Server
Hello, everyone. I am very new to MySQL. I purchased and went through a FriendsOfEd book called "Foundation PHP for Flash". In it, it got PHP, MySQL, and phpMyAdmin installed on my computer, then continued to go through a number of tutorials on PHP and MySQL... ...everything runs fine on my local machine. Much of the stuff is involving pulling data from phpMyAdmin and putting data into it as well. When I load the same files that work locally onto my server (which supports PHP and MySQL), nothing works. I'm certain this is because everything was being tested locally, but that doesn't help me to figure out what I need to do to get the files to work on my server (i use doteasy.com for my hosting). This is frustrating because I completely understand everything I've learned in the tutorials, but none of it does me any good, since I can't put it to practical use (since everything only works off of my local machine!)... Any help would be GREATLY appreciated. Also, I don't know if this helps, but this is instructions from my hosting provider about setting up a MySQL database or something (again, I'm so novice that I'm not sure what it means!):
Database From Localhost To Server
I have created a database using mysql on my localhost. I entered all the relevant data and all that. The problem I have now, is to create the database on the server, but I dont want to re-enter all the data. Is there a way I can copy my databse to the server?
Can't Connect To MySQL Server On 'localhost' (10061)
I just set up a test environment on my local machine. Windows xp pro sp 2 Apache 2 php 5.2.0 MySql 5.0.27 I can connect from the console and run queries just fine but from a php page I try to run. $link = mysql_connect('localhost', 'root', 'my_password'); And it says Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:Apache2htdocsmysql.php on line 3 This doesn't seem to be a php problem because the phpinfo() shows mysql just fine and the mysql_connect is recognized as a function. The password is the same as the one I use when connecting from the console. Any idea what I could have done wrong? Reading Yank's book I can't figure out what's wrong.
'Can't Connect To MySQL Server On 'localhost' (10061)'
1) I have been shutting down the service of the server from the control panel before I start. 2.) Then in one terminal I change directories to point to the correct bin directory. 3.) I restart in that terminal from the bin directory in the 'mysqld-nt --skip-grant-tables' mode. 4.) Open new window. 5.) Change to bin directory. 6.) Then I type in 'mysqladmin -u root flush-privileges password "newpwd"' -- replacing with my password. 7.) Hit return. Now I have done all that and still recieve this error: 'Can't connect to MySQL server on 'localhost' (10061)' *When I set up the server I did check to see if I would get the "Localhost" homepage and did, when I initially installed the software. Can anyone step me through this process and get me beyond this error message. Bear in mind that I am a beginner and may need your assistance in defining terms and methods?
Can't Establish Connection To Localhost With MySQL Server
I recently installed MySQL server on my PC, for the primary purpose of converting MS Excel files to core SQL (using another conversion program to access the server interface)... In my conversion application, I am unable to establish a connection with "localhost".... I tried going into the MySQL command line client, but I can't get past the initial password prompt...FYI, I didn't enter a username and password during installation because I didn't want that..... Anyway, all I really want to do is convert Excel files periodically...Does anyone have any ideas on what I need to do to accomplish this? Also, my conversion application is a trial version and expires in a few days...Does anyone know of any good, FREE conversion applications?
Can't Connect To MySQL Server On 'localhost' (10055)
I have setup my server with following 1. win 2000 server and IIS 2. mysql-4.0.21-win 3. myodbc-2.50.37-nt 4. dbtools 3.23.32 The program runs well for few days. I can insert, delete and edit data in database. couple of days later the system will have the following error. I have to reboot the server and the program works again! ---------------------------------------------------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [TCX][MyODBC]Can't connect to MySQL server on 'localhost' (10055) web_file_name.asp, line XXX ---------------------------------------------------------- user rights, database and table's names are all match. MySQL service started. Just can't connect to database. even in the dbtools program.
Can't Connect To MYSQL Server On Localhost <1006>
I am new to MYSQL and want to get it up and running I have it installed as a service. When I test the installation using the command C:mysql inmysqlshow I get the following ERROR Message: can't connect to MYSQL Server on "localhost" <1006> How do I fix this?
Can't Connect To MySQL Server On 'localhost' (10061)
Whenever I run this script: <?php $mysqli = mysqli_connect("localhost", "root", "rootnow"); if (mysqli_connect_errno()) { printf("Connect failed: %s ", mysqli_connect_error()); exit(); } else { printf("Host information: %s ", mysqli_get_host_info($mysqli)); mysqli_close($mysqli); } ?> I get this error message: Connect failed: Can't connect to MySQL server on 'localhost' (10061) I'm running Apache 2.0.58 with PHP 5.1.4 and MySQL 5.0.20 on Windows XP Home Edition.
Can't Connect To MySQL Server On 'localhost' (10061)
i'm a newbie here and i've just installed the apache,php,mysql package on windows 98 i started the relevant batch file and i'v sucessfully entered the phpdev5 home page however when i clicked on the phpmyadmin link it issued this message: Warning: Can't connect to MySQL server on 'localhost' (10061) is it because of the os i'm using or is there something in my system that is conflict with the installation? appreciate if you could reply soon as the start of my work depends on this.
Host 'localhost' Is Not Allowed To Connect To This MySQL Server
I'm hoping someone can help me out. 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?
Unable To Connect To MySQL Server On Localhost (10061)
I'm trying to install invision pwr board for friends and family. I've got Apache2Triad on Windows, along with some other services like DC, Vent, Teamspeak (I'm a big gammer). I fill out the information to 'install' invision from the web address, click next and it says cannot connect to MySQL server on localhost (10061). I've created the database but didn't add any tables or anything cuz I don't know what tables to create. Invision doesn't say which tables, just says type in the name of the database. Don't know if my password is wrong (using the one I created at install of apache) or if it's a port issue (installing on host machine) etc... I've also tried to install a few other programs the same way; Bulletin Board, 3 different image hosting programs etc... all say the same thing, can't connect. All have there own databases with no tables (cuz programs doesn't say which tables to create). Code:
Error: Can't Connect To MySQL Server On 'localhost' (10061)
I m trying to solve this but i coulnt do it..i get this error when i try to connect to mysql. Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2003): Can't connect to MySQL server on 'localhost' (10061) in c:Inetpubwwwroot est.php on line 20 Error: Can't connect to MySQL server on 'localhost' (10061). But in the command line i can create database and tables.. i m using IIS6, php 5.1.3 and mysql4.1.20.
Once Again: ERROR 2003 (HY000): Can't Connect To MySQL Server On Localhost (10022)
When I try to connect to my MySQL locally via the command line, about 19 times out of twenty, the connection fails with this note: ERROR 2003 (HY000): Can't connect to MySQL server on localhost (10022). The twentieth time the connection is there, and I'm able to maintain and build databases. That's weird, I can't see any pattern. Even weirder: the PHP-pages that use the databases log in every time without failure. I copypasted the password out of the PHP-code, to be sure I have the right password, and MySQL prompts me for the password when I enter the command 'mysql -u root -p'. But when I enter it, it fails. I've tried a lot of obvious solutions (Capslock, enter when te PHP-page is active, or not active, or was recently active, with and without firewall) and they all gave the same pattern: sometimes it works, but mostly it doesn't. Is there anyone with a bright idea to solve this situation
ODBC Can't Connect To MySQL Server On 'localhost' (10013) (2003; S1000)
I have xampp running. WinMySqlAdmin is correctly showing my database "finofix". Using dosbox i can open the database using "mysql -ufinofix -p<pwd>;" and "use test;" So everything looks allright. My application runs on 'localhost'. ODBC sytem-DSN definition: name=finofix, server= ,username=finofix, pwd=XXX, database=finofix When running my PHP application I get: msql,version 32.1.739,Nov 15 2000 ODBC: available data sources: ODBC: finofix - MySQL ODBC 3.51 Driver ODBC: database connect string is 'finofix/finofix/<password>' ODBC: connecting to database ODBC Error: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10013) (2003; S1000)
Error 2003 (HY000): Can't Connect To MYSQL Server On 'localhost' (10061)
I can install MySQL 4.1.18 without problem. I also can connect and run the MySQL right after I install it. The problem is this, everytime I reboot my computer I can't run the MySQL anymore. MySQl service can no longer appear on the task manager's list. I type the following commands in the command window: Code:
Turning Mysql Off On Mac?
My friend is running OSX and has mySQL running, she doesn't know why its running or how it got there, how do you turn it off? What are the steps to go through?
Turning On Logging
I have a database that has various information submitted to it from the internet. I am having problems with people hacking/submitting info that shouldn't be submitted. I don't know how they are doing it but I though that if I turned on the Logging for that particular DB maybe it would give me some clues i.e. IP addresses, ISP, date/time info, SQL Statement executed etc.What form of logging would I need to turn on?
Turning Off Foreign Key Checks
Is it possible to temporarily turn off foreign key checks in a db? I know how to do it from the mysql prompt but I have a number of scripts using Java, etc which seem to be breaking because of the table ordering with respect to foreign keys does not seem to be honored (tables with FKs are declared before the tables the keys refer to). If there was some way to turn off checking for a db, run all the creation and import scripts I have, then turn the checking back on it would save a ton of effort.
Apostrophes Turning Into Question Marks?
This may be easily resolved but I haven't ever encountered it before. I am entering text into my mysql database that contains apostrophes. This field is generally around 500-800 characters. When I add the information, there are apostrophes but when I go back to use the information, all of the apostrophes have been changed into question marks. Any ideas how to keep the apostrophes? or why they are being changed? Also, if I go through and change all the question marks back to apostrophes, they will stay apostrophes!
Turning On Slow Query Logging?
Background: I paid a young admin set me up on a database server. He installed the basic I needed for the server...at my request...No Cpanel...mysql and apache and some tight security w/o even a domain name to SSH into. Unfortunately, he's a busy kid, and teens sometimes don't realize that people depend on them...and well, I can't really seem to get him to do much so I gave up and figured it's a good way to force me to learn all this myself... Well anyway, now I want to turn on Slow Query logging. But before I do that, I need to know how MySQL is running. Is SQLogging turned on already? Where is it logging to? So first thing I want to look up is, when the server is rebooted, what's the command to restart mysql? No clue. How do I change the setting? And of course, the server is production, so when I make the change, it needs to be quick, it needs to be smooth, and I need to be able to roll back to the previous config if necessary. I'm running Redhat Enterprise.
Turning Off Allowing Multiple Non-unique Rows
I feel lazy and I am busy so i don't want to fix my perl code to only alllow insertion of unique rows. I know mysql is set to allow multiple rows of the same thing but I would like to turn that feature off. Is that possible?
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?
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.
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.
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?
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?
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?
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).
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?
Backup Over Network Strategy
I am using MySQL 4.1 on Mac OSX.3(Panther) and I need to write a simple solution to backup all databases to a share on the network at night. I know there are many posts regarding the different types of MySQL backup solutions, I haven't found any useful examples of using CRON jobs to do this (if that is even the best way). Does anyone know of a simple way to schedule this backup to happen and send the .sql files over to a network share? Otherwise I have to keep backing up manually which is not good.
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
Local Area Connection (network)
I have a local area connection (network) where the IP addresses are generated automatically. How do I find a server on a different computer in the same network? IP address are always changing so I have no idea how to find a server.
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??
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","")
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.
|
TRACKER
