Connecting On A Local Machine
I have recently installed Mysql on my local machine. I can access Mysql through the
Mysql Command line client. But I can't connect through mysql_connect.php script. I have always used mysql through our hosting company with no problem. This is the first time I have installed it on my machine. When running the script I recieve the following error
Could not connect to MySQL: Can't connect to MySQL server on 'localhost' (10061
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
BACKUP DATA TO LOCAL MACHINE
Is there an easy way I can backup / copy MySql tables to my desktop PC. It would be neet if I could query these backups once of my desktop PC with MS Access.
Nightly Backups To My Local Machine
I have a MySQL database on one of my sites with shared hosting company which has nightly DB backups. However I would like to have a nightly copy for myself on my local machine. Is there a way to automatically expoxt the entire MySQL database and FTP it to my local machine nightly? Do i just need an FTP program that provides scheduling or are there other ways?
Connecting To MySql On An XP Machine
I have worked with mySql on my localhost and it does fine. Now I am going to try and login to it from another XP machine. Both machiens are Windows XP Pro SP2. What do I need to type at the command prompt to login to mysql on the other XP machine?
Slow Table Access On Local Machine
I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it through ODBC (MyODBC-3.51.10-x86-win-32bit). I'm developing a .NET web application, but I don't think that's relevant. I already had the application running OK on my desktop, and when I created the same environment on the laptop, retrieving trivial amounts of data (5 rows) from a table is taking 6 seconds. Updates the same. IN otherwords any table access takes 5 or six seconds. (Table only has about twenty rows in it). I can connect to the database on the laptop from the desktop (i.e - application runs on desktop, retrieves data from laptop - works fine, not noticeably slower than local on desktop. If I connect the other way - application on laptop, database on desktop, it runs just as slowly as locally. The effect is the same whether I connect to 127.0.0.1 or via the machine name. Code:
How To Insert Machine (local) Time In Mysql
This is a problem I encountered in mysql: how do I insert local (machine) time? To do this in MS Access, just put now(). I tried this in mysql, it does not work. see graph(the red chinese characters means the same thing as above.)
Importing MySQL Database To Local Machine
I have exported a MySQL Database from a remote server using PHPMYADMIN, saved on my local XP machine as an sql file to insert (with name _DB_.sql) but am not sure how to get this to run on my local XP machine which is running MySQL locally; When I view the file on Notepad it appears to be executable in some way as it includes CREATE command etc. I tried the following from MySQL command line SOURCE C:/Program files/MySQL/_DB_sql but can't see any evidence of the database having been created on my local machine.
Dumping My Live Database And Then Putting It On My Local Machine Problem..
I have tried copying the dumped sql code in mysql query browser once dumped from live and it doesn't execute it, i have to extract it line by line and that would take forever to do this all, is there an easier way to do this or can someone run me through the basics on how to achieve this? i have on my live site: 4.0.25 (patched) and on my desktop computer : 5.0 Would this be part of the reason? i don't know..
First Time User Need Help Connecting To Local Db
I've worked a bit with creating and connecting to databases online using PHPAdmin but I'm trying to set up a local environment and I know NOTHING about that. I installed MySQL 5.0 yesterday and it seems to be OK. At least I can bring up the command line client and get the mysql prompt. (I'm on XP Pro, btw.) I really don't know what to do next, though. I've built my db model in DBDesigner4 and supposedly, you can use that program to create and synch your database. I tried doing that and I keep getting the invalid user name/pw error message. I don't know if I have to create an empty db first or if there's just something wrong with the user name/pw. I'm using the pw I created when I set up MySQL and using "root" as the username. Anyone have any idea what I might be doing wrong? Do I need to create the db on my machine first? If so, how do I do that? Any ideas why I keep getting the invalid username/pw message?
Connecting To MySQL On Local (MacOSX)
I am a very new a PHP and MYSQL. I am following the Sitepoint book "Build Your Own Database Driven Website...." Platform: MacOSX: Problem: pg 19. I am installing MySQL: I have typed sudo /usr/local/mysql/bin/mysql/bin/mysqls_safe It comes back with: A mysqld process already exsists. Question: How do I get from there to: mysql>
Two Versions On Same Machine
I had MySQL 4.2 - working fine. I saw version 5 is now stable so I downloaded and installed but did not run it (I think!). Carried on with 4.2. Then one day MySQLAdmin and Query would not log me on. I checked via the cmd line utility and when I typed in the password the window dissappeared! I opened MySQLAdmin again and reconfigured the log-on o 3307 (I remember this was default when I installed 5.0). OK, the server must be running. So keep with 5.0 as I managed to restore one of my schemas. I wanted a later version which is only in the 4.1 directories and copied it across BUT 5.0 does not see it. But when I go to stop and restart the 5.0 server in Admin as soon as I go to the server tab to do this it stops automatically! AND will not restart.
Speed From Second Machine Bad
I am new to MySQL (mysql-4.1.7-win) with MySql ODBC (MyODBC-3.51.10-x86-win-32bit) and (vb 6 with service pack 5 or Access 2003) to connect via adbc to MySQL. My seccond machine are terribly slow and would like to know if there are any suggestions.
Load On My DS Machine
I've got dedicated server , 30mbp/s line, and solving very strange issue, my hosting told me i burn about 2.8mb per sec., so i get a lot of traffic, i don't use mysql very often, i use mysql only for special cases, no more than 5 requests at same time. i'm checking top function via telnet console, and i can see sometimes huge loads on server, from 0,8-1 it skips to 20, then 30, 50, 100, somewhere between 20-30 it crashes mysql, and i can't connect , sometimes it went to 150 load, and then it slowly going back to normal.
Migrating My Mysql DB From One Machine To Another
We are moving our mysql db from one machine to another -- both linux. Origin machine is running mysql 3.23, destination machine is running mysql 4.1. Can we simply copy all *.MYD / *.MYI / *.frm files from one machine to the other and have things work? Or do we *NEED* to do a text dump of the tables, and reload each one individually on the new machine?
How To Go About Re-installing MySQL On A New Machine?
I have MySQL installed and a database already built and loaded with data that is collected nightly from the mainframe database. I am currently running on NT and will be loading a new image onto the machines to change the operating system to Windows2000. From what I understand, I will need to copy all files I want to keep, including my database. My question is, once the new image is on, I will need to re-install MySQL, is it as easy as just copying back the MySQL directory back onto the machine and the database still work? If not, can someone tell me what the general process is to do this without losing the database and any issues that I am going to run into?
Can't Connect From Remote Machine
I am writing some code in ASP3 on an XP windows machine. I am trying to connect to a linux machine which is Redhat 7.3 that is hosting my MySQL database. I am use this code to connect. objConn.Open "Driver={mySQL};Server=http://4.7.165.99;Port=3306;Option=131072; Stmt=;Database=DB name;Uid=User Id;Pwd=MyPassword;" This is the Error message I keep getting: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have been looking all over the web, and can't find how to fix this issue, can anyone help me?
Anyway To Run 2 Instances Of MySQL On The Same Machine?
I was wondering if there is anyway I can run 2 instances of MySQL Server on the same machine, the reason is I have one machine and I want to be able to simulate my program which really talks between 2 systems accessing their own MySQL server datas but I dont have 2 machines with me all the time to do this, it would be great If I could somehow manage this.
Connect To MySql From Another Machine
I have RHEL 4.0 installed on a x86 box, and am using the standard MySql server that comes with RHEL 4 (MySql version 4.1.12). I tried downloading the Administrator tool, but had problems installing it. (This issue has already been reported at http://forums.mysql.com/read.php?34,65093,65093#msg-65093). I have an Administrator install on a Windows machine, and I want to use it to connect to the MySql server on the RHEL box, but get the error that says: Host '<my_machine>' is not allowed to connect to this MySql Server. Can I use the Windows Administrator tool to connect to a MySql server on Linux? (same network and sub-net) During the RHEL install, the firewall option has been disabled, so that's not an issue. I think I need to add an entrry somewhere in the MySql db that allows other machines to connect, but am unsure of how to add it, and what the syntax looks like.
When Should I Scale Out From One LAMP Machine?
I just have one server that runs Apache, MySQL, PHP. It handles requests fine and never had problems. When should I think about a small step into scaling? By maybe having an independent MySQL server? How many QPS (Querys Per second) (approx) on the MySQL DB will it be optimal for me to have MySQL on a seperate maybe more powerful machine? The current server has 1GB Ram and intel duo core processors..
Connect To Another Machine With SQL-Server
just installed a mysql server, database and user on one machine [1] (debian-linux) Now I want to connect to the database from another machine [2]. Actually I am sure that I have to configure connectors or named pipes. But I can't find these topics in the manual. When starting mySQL as user on the server everything is ok. When starting mySQL as user on the client computer [2] I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) actually '/var/run/mysqld/mysqld.sock' is not existing. What do I have to put into that one? Or rather into /etc/mysql/my.cnf
Access MySQL From Another Machine
how do I make MySQL server accessible from the network to other web servers. Right now I have the MySQL server and the web Server all on the same server. But I want to have a server that is solely responsible for MySQL and 3 others servers that are responsible for web page serving via Apache. The web servers need to be able to access the MySQL database. |-----| |----| |----| |Web | |Web | |Web | |-----| |----| |----| ! ! ! !!!!!!!!!!!!!!!!!!!! | |----| |My- | |SQL | |----|
Usinq MySQL And MS-SQL On The Same Machine?
I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'?
Usinq MySQL And MS-SQL On The Same Machine
I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'?
Move SQL Files On Same Machine
How do you move the directory where MySQL files reside and inform the local MySQL server of this? I'd like to be able to move my data files to different locations on my hard drive AND move them to another machine when I have to use them on the road.
Moving Database To New Machine
I'm trying to relocate my site to a new host and I'm having a lot of trouble moving the database. I did the export for the old host/database with phpmyadmin. It saved to a txt/sql file with no problems. When I try to import it into the new host/database I get all kinds of syntax errors. Then I realized, after purchasing the new host that: Old host/db = MySQL version 5.0.24a New host/db = 4.0.27 Is there any way to convert a 5.0 db to 4.0?
Create Dsn On Linux Machine
i am raghvendra. i am working on linux. i am using a php4 with apache 2 on linux machine. i want to create a dsn on linux machine. but i donot know how can i do this. my database is on remote windows machine.
Md5 Problem After Moving Database To Another Machine
I moved my MySQL database to my own web server (Windows NT4 server, Apache 2.0.55, PHP v4.4.0, and MySQL v4.0.26). I used "mysqldump" and "mysql -u root -p ccs < sqldumpfile" to backup and reload the tables. Some PHP scripts that work fine on my ISP (MySQL v3.23.58) do not work on my local PC (MySQL v4.0.26). The part of the select statement where the problem lies is: and password='".md5($MD5_PREFIX.$_POST["password"])."' I did some testing via the mysql command line interface and it appears that the md5 function is generating a different value. If I set the password to '123' with no encryption and remove the md5 stuff from the PHP script it works (the $MD5_PREFIX has not been changed and I even did some testing in mysql by hardcoding the value) -- so I'm pretty sure the problem lies with the md5 function. Is there a difference in md5 between different versions of MySQL? If not, can someone point me in the direction of a solution?
Mysql Runs On A Machine With Multiple NIC.
When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of user@localhost instead it will be equal to the rights of the user@PrimaryIPAddress. Is this behaviour correct or a bug.
Moving Database To Alternative Machine.
Have installed version 4.1 on 2 machines. I am trying to copy a database that i created on one machine by simple going to the data folder and copying the database folder pasting it to a removable device. I then copied the folder into the data folder on my second machine. However, when i attempt to do a select * on any of the tables on the second machine, I am told that the table is corrupted or does not exist.
MySQL Administrator On A Remote Machine
On my internal network i have mysql running on a test/development webserver (windows), and im trying to use the GUI tool MySQL Administrator on another networked pc but it wont work. It keeps saying 'Error 1045 Access Denied....' I can ping it fine, and MySQL Administrator GUI works on the server itself.
Blank Password When Restarting The Machine
I mainly use MySQL Administrator to create/update table/users/etc. And I noticed that whenever I restart my machine (Windows 2003 Server with MySQL database running) and login to the MySQL Administrator, it takes blank or wrong password for any user account including root. So I end up resetting my root password. Does anyone know why it keeps happening?
Installing MySQL On WIN98 Machine
I'm trying to install mySQL on my WIN98 machine (I ran the setup.exe file), and am never prompted for a password when I run the configuration wizard. When I try to then run the command window, I'm asked for the password. Can I change some config file or ini file? I'm selecting either Detailed or Standard Configuration, and don't ever get the prompt for password. The checkbox for "Install as windows service" is disabled, so I can't check it.
MySQL VmWare Virtual Machine - Password?
I just downloaded and installed the MySQL-provided VMware linux virtual machine. To logon to it there is a linux user 'lxuser' provided. Anyone know the password for lxuser? root?
Multiple MySQL Server Installations On One Machine
First, does MySQL architecture support the creation of multiple MySQL server installations on one machine? (Specifically, I am hoping for two different MySQL 4.0.12 servers on the same machine for two different departments with two different DBAs.) If so, what naming convention (and infrastructure) distinquishes between the two MySQL servers? What network connectivity file entries would exist to differentiate between the two servers such that I could connect to one or the other servers from a remote client?
Machine Name & IP Address Fails For Remote Admin Login
I've just set up 5.0 on both a desktop server and a laptop with an essentially default install using WinXP (brand new, naive user here!). I find that when I use the Administrator Tool that I can only log into ServerHost: "localhost" using Username: "root" and the password I made. This is made worse as I can only hit the desktop from the laptop using Remote Desktop connection. What I can't do is either use the WinXP machine name, or the IP address for the Serverhost. This becomes an issue for the laptop especially as the IP address can change (although this is accessed through a VPN, so the WinXP machine name might be used). I am quite confused by the documentation regarding servernames, bindings, hostnames, etc.
How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create a set of database tables for me. Supposedly I type the following on my linux box and its all supposed to work... mysql (ENTER) . mysql_dump.sql.txt When I type myslq <ENTER> I get a command prompt that looks like this... mysql> But I don't know how to change directories from that command prompt to the directory where mysql_dump.sql.txt is located. Can someone tell me how to change dirs at the mysql> prompt?
Variable LOCAL
I'm trying to load data to my mysql 4.11 db from txt files, using LOAD DATA INFILE. I received the following message: "The used command is not allowed with this MySQL version" In the manual that message means I have a LOCAL variable issue. I set the variable to off (set variable LOCAL-infile=0;) but it still doesn't work... I got the same error message. (The LOAD DATA command is been running inside a Visual Basic program in a client computer) The txt file is inside a folder of the server. If I remove the LOCAL, the error message is 'Cant get stat of 'vendedor.txt' ' What can I do?
Local-infile
I'm running a server on Linux started with --local-infile=1 I start a client with --local-infile=1 It does not complain about the argument. Then I can do this: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 9 to server version: 4.0.15-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> show local variables like "local%"; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile | ON | +---------------+-------+ 1 row in set (0.00 sec) BUT, if I do this... mysql> load data local infile 'whatever' into table whatever; I get this... ERROR 1148: The used command is not allowed with this MySQL version Yet I am able to use an equivalent command without "local". SO, what don't I know that I need to know?
Allow All Local Ip For A User
GRANT ALL PRIVILEGES ON `f00`.* TO 'john'@'192.168.%.%'; OKI, but: SHOW GRANTS FOR john@% gives error, why? It should list everything which has john@(something) connected to it. So why doesn't it work? Can I use a Connection-specific DNS Suffix 'localf00domain.local'? that would be great beacause it would work independent on what ip you logged in from Also, when I connect to this DB with MySQL guitools etc I dont intend to write 'john'@'192.168.%.%' as my username. I am going to write john and pass the rest is for MySQL to figure out, anything else seems very stupid, right? Id be really greatfull for asap reply because I am on a horribly short timeline. Thanks. P.S. As a side note I just have to mention that the forum search function leaves alot to be desired. It cannot seem to handle generic searches like "'192.168.%.%'" for example.
Local Time
I'm not if this belongs here or in PHP. I run this query Code: "SELECT id AS ID, rain AS Rainfall, f_name AS Firstname, l_name AS Lastname, property AS Property, town AS Town, date AS DATE FROM $table ORDER BY date DESC, rain"; Data is added by a form, and the default value I put for time is NOW I'm downunder, and, I want today's date displayed ( today as we know it), not a date from the other side of the planet. I found SET Time ZONE EST - but I wasn't sure where to use it - or if that was really what I needed.
/usr/local/mysql
im getting -can't connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (2) when i try to start.... but for some reason my server crashed last nite... on reboot this folder is no longer there?whats supposed to be there?
Name.local.err (MySQL Won't Start)
After reinstalling OS X 10.3 from disk, then installing the developer tools, I've installed MySQL several times now as both a native binary and compiling from source. Every time I get it configured and make && make install it just fine (except when I try the binary install). I set up my .bashrc to use the newly installed version and everything, but whenever I try to run it I get the following: alice:~ me$ sudo mysqld_safe touch: /usr/local/var/alice.local.err: No such file or directory chown: /usr/local/var/alice.local.err: No such file or directory Starting mysqld daemon with databases from /usr/local/var /usr/local/bin/mysqld_safe: line 360: /usr/local/var/alice.local.err: No such file or directory /usr/local/bin/mysqld_safe: line 366: /usr/local/var/alice.local.err: No such file or directory STOPPING server from pid file /usr/local/var/alice.local.pid tee: /usr/local/var/alice.local.err: No such file or directory 060804 17:26:06 mysqld ended tee: /usr/local/var/alice.local.err: No such file or directory Been googling for days, just can't figure it out, so I turn to you guys! Any ideas?
Local Version Same As Remote?
I'm setting up a local development environment and wondering which version of MySQL I should be installing. I will eventually upload files to a server with MySQL 4.0.15, should I use this version for my local dev setup, or can I use 4.1.22 without any problems?
|
TRACKER
