Local Remote Command Control For Mysql?
ok, My website is hosted remotely onto my Web Hosting company. and i want to control MySQL remotely or locally in my computer without using PHPMyAdmin.
I notice using PHPMyAdmin is very tiresome and also i'm thinking
if there is a good alternative for PHPMyadmin so that i don't need
to enter my CPANEL website everytime i do the work using PHPMyadmin.
I'm thinking perhaps just like Microsoft Express/Outlook functionality instead of opening my Yahoo emaail account they will be sending the incoming and outgoing messages into my email automatically. This are the features that i'm looking for as an alternative for PHPMyAdmin.
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL Remote Backups - No Access To FTP Or Remote Command Line
I have a mySQL database located on a remote host's server. I would like to schedule a task on my local Windows computer to retrieve a backup/dump of this remote database. I have contacted my host, and they indicated that the server is only open to the Internet via mySQL. Therefore, even if I did have access to that server's command line (which I don't) to create dumps via mysqldump, I would not be able to retrieve via FTP. Does anybody have any ideas as to how I can generate backup files from my local computer through a local command-line interface? I have done it through a GUI (DBTools), but I would like to have it done via DOS batch, so that I can schedule it. Does anyone know of any mysql backup GUIs with command line switches? Or can somebody recommend an alternate means of getting a local backup?
View Replies !
Control Center :: GUI To Connect To A Remote Mysql Database
I'm trying to get the GUI to connect to a remote mysql database from my client machine. What is the proper syntax for this in the GUI? I have tried everything with no luck: using the ip of the host, using the complete dns hostname of the host, using root as the user, using root@hostname as the user. I keep getting access denied for every attempt. I'm sure I am using the correct password.
View Replies !
MySQL Max Connections Remote And Local
My website runs on two servers. One is mean't for PHP and the other is the database MySQL. Whenever a request is made, the PHP attempts to connect to the MySQL via a remove host variable in the mysql_pconnect() function. This works fine, however when it comes down to having lots of connections in the my.cnf file, which one do I edit? max_connections = 1000 Now do I set this in the MySQL only, or do I set it in the PHP server as well?
View Replies !
Remote Control
I have MySQL running on a desktop computer that I log into through logmein.com and this is not the best solution. How can I connect remotely to use the MySQL Command Line Client on my desktop so I don't have to wait so long for each line to appear? I should also point out that this computer is on my LAN, so I shouldn't have to configure the router. One problem I am running into right now is that when I try to make a new table, I keep getting error 1064 (42000) and I'm not sure why because everything looks correct. Code:
View Replies !
Local Application Connection To Remote MySQL
I have managed to set it up on a remote server, I would like to know what' the best way to write an application, pref. in C++, that can connect to the remote DB over the internet. Basically, I hope to have a program running on a local computer collecting information and dumping it into an online MySQL database.
View Replies !
Connect Remote JSP Files With Local MySQL Database?
I use dreamweaver 8.0. I have my jsp files on the remote server Z:. I have my local computer 'A' connected to this server. I have my MySQL database on my 'A' computer. I want to know how to connect the remote JSP files with the database? Currently I am using jdbc.odbc drivers on 'A' computer. But my server computer has Linux and uses org.gjt.mm.mysql drivers. Which drivers and Where should be the drivers?
View Replies !
Copy/move Mysql Data From Local Machine To Remote Server Database
I have an website that is host on web server and here have a database that have only one table name is "user" Table fields are: name Id no email phone And I am using same site in my local machine. I always use my local machine for data entry and everyday end of the day I want to transfer data by clicking one button from my local machine database table to my remote server website database table. How can I transfer data from my local machine database table to my remote server website database table.
View Replies !
LOAD DATA LOCAL INFILE MySQL Command
Has anyone had any luck using the "LOAD DATA LOCAL INFILE" command with MySQL++? The query string shown below executes without any problems when using MySQL Query Browser (Version 1.1.18). LOAD DATA LOCAL INFILE 'c:aAZ_combined.dat' INTO TABLE stocks FIELDS TERMINATED BY ','; However, when I try to use this very same command in Visual C++ 7.1 using MySQL++, the command doesn't execute, and error_code is set to "1". error_code = mysql_query(pConnection,"LOAD DATA LOCAL INFILE 'c:aAZ_combined.dat' INTO TABLE stocks FIELDS TERMINATED BY ','"); Is there something special that I have to do to get this particular command to work properly? Note that I have gotten other commands to work just fine in Visual Studio 7.1 using MySQl++. For instance: error_code = mysql_query(pConnection,"CREATE TABLE stocks (ticker CHAR(7), date INT, open FLOAT(2) UNSIGNED, high FLOAT(2) UNSIGNED, low FLOAT(2) UNSIGNED, close FLOAT(2) UNSIGNED, volume FLOAT(2) UNSIGNED)"); This command worked in the same fashion that it did when using MySQL Query Browser. Can anyone offer any insight into what I'm doing wrong here?
View Replies !
Connecting To Remote Mysql With Command Line
my client got a dedicated box at rackspace but now that its time to move the db from my localhost to the remote server i find out there is no phpmyadmin installation. im also unsuccessful in connecting with Navicat (somehow that NEVER works ...). can anyone offer any advise on how to connect either with my GUI or with an SSH client. or SSL? having always relied on a GUI to work with db's im totally lost!
View Replies !
How To Connect To A Remote Host Using MySQL Command Line Client
I can't establish a connection with a remote host using MySQL Command Line Client. ODBC conn setup successfully. Databases on this remote host can be reached using Crystal Reports. I open MySQL Command Line Client > prompted to enter a password > done successfully so I can connect to local databases. The following is entered to connect to remote host: mysql -h hostname -u myuserid -p but once I hit enter nothing happens.
View Replies !
Copying Remote DB Into My Local PC
I want to get,from a remote DB, some data fulfilling a column-condition (say IP.dest = 'IP address') and putting them onto my local PC, all from mysql shell... I've already installed mysql on my local PC and have access to the remote machine. in pseucode could look like this: mysql> copyDB_command condition remoteDB > localFile.txt
View Replies !
Link Local DB To Remote Via SSH
I have a SSH connection to a server with a database on it holding all of my application data. I also have local databases with other information that is related to the remote information. E.g. Server has account usage by account number, local database has account number and local contact. I currently .... 1. SSH (with Putty) to the server 2. Run a script to dump the query result to a text file 3. FTP the file to my local machine 4. Open the file in XL, convert to columns 5. Insert vlookups to match the local data to the retrieved data. How can I create a link from my remote database to my local database so I view it as a linked table? I know with Access I can (in theory) connect to an ODBC data source and query it, so then I can run a cross-tab query between my local data and my remote data. Is there any way to link to a remote database via a SSH? What do I need enabled on the server to allow me to do this?
View Replies !
Synchronizing Local And Remote
I have a wamp server website with mysql locally (laptop at home) and a puclic hosted website with mysql. I usually make changes locally test them and then upload the folders, etc. I need some easier way than just exporting the DB and going to my remote CPanel and phpMyAdmin to import the DB to get the changes synchronised. Can someone advise on a good method/program which will do this for me? I envisage something on my home setup which can (FTP?) inject the updates to the public DB. Maybe something which works both ways in case I change the public one first (but that's an extra really)?
View Replies !
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?
View Replies !
Copying A Local DB To A Remote Host
I have MySQL running locally on a W2K machine and have imported a large database of over 300,000 records from Access to MySQL. Now I need to isolate this database and upload it to a remote host. I'm a little confused, as the file ibdata1 in my data directory just appears to be a dumping ground for all data in all databases. I have tested this by creating a test database and adding a couple of records. There is a folder named after the database I want, containing .frm and .opt files. How do I isolate the data I need into a "standalone" form that I can use on our remote host? Again, I know that this is a real dumb question but I've been unable to find an answer anywhere else.
View Replies !
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.
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 !
MySql Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I cannot seem to display more than 1000 rows in my result set when I know that there is 1534 rows. I know that it is a setting somewhere, but is it in MySql or in the Control Center somewhere. I am running this on a Windows 2000 machine.
View Replies !
Permissions In Mysql Control Center
I need to allow 3 different servers to access my MySQL Server. How do I do this? Also, I was told that having MySQL configured so it doesn't restrict access is bad - how do I make sure that's not the case?I feel like I know what they're saying, but I don't know how to actually implement this in the Control Center, and I must be using the wrong keywords because when I look it up, all I find is stuff on how to connect to the MySQL Server from my web page using php (which is what I'm using and already doing).
View Replies !
How To Control Mysql In Hosting Server
I am a ASP programmer. I use MS Access for quite some time, and I am to switch to MySQL. The way I use Access is create tables in my computer and upload it. When I want to do backup, I will download it and make another copy locally. 1. How to create a MySQL DB and Upload it? 2. How to modify the DB structure? For example, create index for certain field? do I have to download it and change it locally? 2. How to download and make backup?
View Replies !
Importing Tables Using MySQL Control Center
I am using Dreamweaver MX to create a data-driven web site. With the VPS hosting plan we're on, our remote FreeBSD server only supports the PHP application server. PHP requires MySql. Thus, I installed a copy of MySQL Control Center 0.9.2 beta. (I prefer a GUI and not command prompts unless necessary.) The information I plan on using in developing this site will be derived from a contact management program called GoldMine. The records will be exported into DBase tables, and somehow imported into the MySQL/PHP/Dreamweaver environment. From what I can gather so far, the MySQL environment I'm working under will not work with Access or DBase tables. Thus, I've created a new table in MySQL and re-created the various fields to match what I have in the DBase table. Now I want to import all the records I have in my DBase table. In fact, I will need to update the MySQL database weekly. So far, I have been successful in making all the connections work, except for importing the table into MySQL. In the MySQL Control Center, once you connect to the database, there is an option to import, but it is dimmed out. How do I make it work?
View Replies !
What Parameter Control Mysql-bin Logs Size?
ls -althr Unix file system listing of bin files. 1.1G Mar 27 08:53 mysql-bin.000010 1.1G Mar 27 19:48 mysql-bin.000011 1.1G Mar 28 01:28 mysql-bin.000012 I see ALL my mysql-bin logs are about 1.1Gb in size and there must be an parameter that tell them to switch when It reaches this value but I can not see which parameter that controls this in ‘show variables’ or my.ctf - I would suspect it was max_binlog_size but the value does not come close to 1.1.G – do ANYBODY know what tells them to be 1.1G in size? mysql> show variables like '%bin%' ; ....
View Replies !
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
View Replies !
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (11)
We run Bitrix CMS and upon installing the web statistics module, it will sometimes show this error: Error! mysql_connect('-', '-', '-') Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) The max connections has been raised to a 1000... and SHOW GLOBAL STATUS says for the maxed used connections: Max_used_connections 273 The server does not really max out...
View Replies !
/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?
View Replies !
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
View Replies !
Local Interface To MySQL
I need to harvest data from MySQL tables. My experience is with MSSQL and Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't need to manage anything. I just need the data. What kind of interface can I use to query and save data locally? I don't see any MySQL drivers available when I try to setup an ODBC from my desktop. Can I download one somewhere?
View Replies !
Installing Local MYSql
I want to install mysql on my local machine so I can test scripts and run code. Does anyone know which package I need to use and how to do this?
View Replies !
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
View Replies !
MySql Local / Networked
I have been asked to set up a local offline website to update and manage our current office inventory list. The 3 computers this needs to be accessible to, all share a networked drive. Is it feasible, that I could locally install a WAMP configuration (Windows, Apache, MySql, PHP) to make this all come together? Would I be able to configure the MySql database to be accessible to all computers from the networked drive? Are there any other factors I should know before I begin with this project, or is there a simple better way to do this (other than fully hosting the page online.)
View Replies !
/usr/local/mysql/bin/mysqld_safe &
after I run /usr/local/mysql/bin/mysqld_safe & I got the screen output like this [1] 1395 /home/admin# Starting mysqld daemon with databases from /usr/local/mysql/var My qeustions are What does [1] 1395 mean? I didn't see this when I run "/usr/local/mysql/bin/mysqld_safe" & before. And I didn't change anything about mysql on the server since the last time I run "/usr/local/mysql/bin/mysqld_safe &".
View Replies !
Local Mysql For Backup
On my web-hotel I use mysql för mastering my database. Now I want to install a mysql on my local machine as well. One of the ideas I have behind this is to use the local mysql as a backup för the database on the web hotel. My provider makes backups on a regular schedule, but I want to be independant of this. Is this a good idea? I am running windows-2000 . What is the simpliest way to download a suitable copy of Mysql?
View Replies !
Local MySQL DB With PHP And Apache2
this is the environment: Windows XP Professional V2002 SP2 Apache Server 2.0.54 PHP 5.0.5 MySQL 4.0.21. All applications are working as such (Apache, PHP and MySQL DB), but when I try to connect to the DB, nothing happens (not even an error). I was reading around a bit and tried some stuff. Eventually I found some things I haven't done): #### went into php.ini and inserted the path of the apache document root path into the doc_root field in addition inserted the extensions dir path to the extension_dir field in php.ini, which was c:phpext scrolled down to almost the bottom of the php.ini file and deleted the 'comment' character to activate the php_mysql.dll extension. ### Now, I did this, but when I restart the Apache Server I get two error messages: PHP Startup: Unable to load dynamic library 'C:phpextphp_mysql.dll' - The specified module could not be found. This does not make sense, because the dll IS in that folder. I even reinstalled PHP and reconfigured the ini-File. Nothing. And it really, really, REALLY am getting annoyed here (yes, I tried forward slashes).
View Replies !
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?
View Replies !
I Want To Make Transfer Data Between MySQL Server To MySQL Local .
I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux ) ::::: Apache .. ::::: Linux PC Client = ::::: Window ::::: MySQL run localhost ( for window ) How i transfer data from mysql server to mysql local .? Caz i don't want to connect via 3306 port .. Can i use others way?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I've installed MySQL-4.0.14 under RedHat 8, using both rpm's and compiling from source. When I try to run MySQL, I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' After much searching on Google, and reading many newsgroup threads on this error, as well as reading the manual, I'm still stumped. Most of the advice I've found suggests that the path to mysql.sock is wrong, which makes sense, but I don't have the file mysql.sock anywhere on my machine, so obviously I can't correct the path.
View Replies !
MySQL-error : Can't Connect To Local Mysql Server Through Socket
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin):: #2002 Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock On the website of MySQL this error is mentioned but I found no solution. In /var/log/messages the following log occurs : localhost kernel: audit(....): avc: denied {write}for pid=2458 exe=/usr/sbin/httpd name=mysql.sock dev=hda13 ... What I have tried : - mysql.sock is srwxrwxrwx, seems ok, but dont know what the s stands for - the dir /var/lib/mysql was drwxr-xr-x and I changed it to drwxrwxrwx : no effect - tried different version of phpMyAdmin : same error - installed my website and got the following error : No connection possible with database (in the next version I will improve the error-messages) - through commandline there is no problem in connecting to mysql (log in, create databases, inserts, deletes, uploading dumps, making dumps, ....) What is the solution or what else can I try ?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I am using a Mac running Mac OS X 10.4.8 and I have successfully installed MySQL on it but when I go to run it using the command sudo ./bin/mysqld_safe & all it does is display a random dumber and when I try the command ./bin/mysqlshow -u root -p I get an error message saying Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
View Replies !
|
TRACKER
