Setup Remote Access
How would you allow remote database connections on MySQL 3.23.58?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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?
Access Denied For Root - New Database Setup
I have started the 'Build Your Own Database Driven Website Using PHP and MySql I have installed PHP and MySql' book, and i have a problem: I have put in the comand prompt mysql -u root mysql This gives me an error 1045 access denied for user root @ localhost ....
New Account Setup Not Working As Expected - Access Denied
grant all on hibernate.* to hibuser identified by 'password'; Then I tried to login via: C:MySQLMySQL Server 5.0in>mysql -uhibuser -p Enter password: ******** ERROR 1045 (28000): Access denied for user 'hibuser'@'localhost' (using password: YES) The only way I could solve this problem was to create another user 'hibuser"@'localhost" Can someone tell me what is wrong and what I can do to fix it? I now have multiple instances of my users and have to manage each as a separate entity: mysql> select host,user,password from user; +----------------------+---------------+-------------------------------------------+ | host | user | password | +----------------------+---------------+-------------------------------------------+ | localhost | root | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | | 127.0.0.1 | root | | | localhost | | | | production.mysql.com | | | | % | pentaho_admin | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | | % | hibuser | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | | % | pentaho_user | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | | localhost | hibuser | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | | localhost | pentaho_admin | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | | localhost | pentaho_user | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | +----------------------+---------------+-------------------------------------------+
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?
Remote Access
I have a MySQL server running on my iMAC and am able to access my databases locally. What steps do I have to do to allow access from a remote PC thru TCP/IP ? The manuals say it can be done but don't specify what is involved.
Remote Access
I've set up a User account called 'test' for my MySQL database (for use from my Uni). The host value for 'test' is '%' but for some reason I can't connect when accessing the Database from a dynamic dns name. Test can connect when the JDBC is run using 'localhost' but the connection attempt simply times out when I change the URL to 'bailz.dyndns.org'. The PC is running behind a router but I can access the web server no problem from outside... it's just MySQL via JDBC that I'm having trouble with.
Remote Access
I have: Computer A, my computer, through which I can pretty much install anything I'd like. Computer B, my webserver, a computer on the network that I installed mySQL, and that uses IIS for its server. It also uses Windows, and not UNIX/Linux. Anyways. I'm trying to setup MySQL so that I can use it remotely from Computer A, either using it directly with something like SSH or Dreamweaver/PHP. However... I'm completely new at this.
Remote Access
I am facing problem when i try to connect to a remote mysql server using mysql_connect command. It give error " Can't connect to MySQL server on {IP} (10061) in" I have even added one user and gave it permission to connect from any host (%) and allowed DB rights too. I have checked that mysql variable -skip_networking is also off. There was fire wall installed on mysql server but that has been removed but still problem is not solved.
Remote Access Through SSH Tunnel
I've got a MySQL database being hosted by a company. The site has phpMyAdmin for external administration, but I'd like to use a program like EMS MySQL manager, or maybe even an OBDC connection for certain things. But I can't get the SSH tunnel to work. I can access the account using an SSH logon through putty, and once in, I can access MySQL using the terminal. But I can't get port forwarding to work. If MySQL is working with phpMyAdmin, shouldn't it be able to work with an SSH tunnel? Code:
Using MS Access With Remote MySQL
I'm trying to use MS Access in order to list, edit, and add data to a MySQL database located on a remote server. I can get the tables to link (via ODBC), and display OK in an MS Access form. However, I can't seem to edit/change any of the fields. Suggestions?
MySQL Remote Access
I want to be able to access my MySQL database that I installed on linux, from my Windows 2000 machine. I will be using the database from various programs such as VB 6.0, MS Access, etc. I have installed MyODBC on both my linux machine and my Windows 2000 machine. I want to be able to access the database through this MyODBC connection on my Windows machine but I'm not sure how to go about setting this up on both machines. I'm am looking for some advice as to how to set this up or if anyone can point me to some good information on the web
Connect To Remote MySql Using MS Access Via IP
I have a MySql database on a remote webserver. I used phpMyAdmin to set everything up. I would like to use MS Access as the front-end to link to the tables in the remote MySql database so I can edit, add, delete data using an Access form. My phpMyAdmin is on a server that has an IP address (like 12.34.56.78:8585). So I tried setting up a DSN on my home system using the same IP address and MyODBC Connector. When I put in the IP as server name, and the user/pass info, when I click test it just sits there for a long time and then I get an error: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '12.34.56.78' (10060)
Remote Access To My Mysql Server
I ran grant all privileges on *.* to 'root'@'%'; I've got two questions... firstly, when I try to get to it from another machine on the local network it tells me access denied... secondly, I'm on a soho network with a NAT router... what port/ports do I set up to access the mysql server from the outside?
Cannot Remote Access On Non-default Port
On MySQL server running on UNIX machine I changed the default port 3306 to 40006. From Windows PC I ran this command: mysql -p -u user1 -h mysqltest:40006 testdatabase It does not work. It only works if I use the default port 3306. How can I remote access on non-default port?
Enable Root Access From Remote Machines?
I just setup MySQL5 on a Windows 2003 dedicated box and one of the last questions in the Instance Configuration Wizard had a check box labeled: "Enable Root Access From Remote Machines". I did some research but could not figure out what that meant. I log on to my box using Remote Desktop so if I don't check this will I able able to have root access? I am guessing this is a security issue. I want my box to be as safe as I can. Here is how I have the MySQL config file setup (from the Instance Configuration wizard): port=3306 basedir="C:/Program Files/MySQL/MySQL Server 5.0/" datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/" default-character-set=latin1 default-storage-engine=INNODB sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=100 query_cache_size=49M table_cache=256 tmp_table_size=52M thread_cache_size=8 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=103M key_buffer_size=76M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K innodb_data_home_dir="C:/MySQL Datafiles/" #skip-innodb innodb_additional_mem_pool_size=4M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1524K innodb_buffer_pool_size=148M innodb_log_file_size=30M innodb_thread_concurrency=8
Remote Access To MYSQL Server Host
I am trying to access a mysql database on my old host (I'm doing a CMS migration to something on a different server.) My hosting company doesn't have a CLUE what I'm talking about when I say MYSQL server host (I'm not even sure I do). They keep telling me it's 'localhost'. I can access both dbs through their prospective phpmyadmins. Is there any way I can find out what the host server is? I would just export the db and then import it into the other one, but all attempts at that have failed.
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.
Remote Access Not Working: Error 1251 Client Does Not Support Authentication Protocol Requested By Server
I'm trying to set up my MySQL database for remote access. I've never been a DB admin so this is all mostly new to me. I am binding to my public IP address, and I have created a new user with the following grant commands run from the mysql command line on the server: mysql> grant all privileges on prs_data.* to 'username'@'%' identified by 'change'; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on prs_data.* to 'username'@'localhost' identified by 'change'; Query OK, 0 rows affected (0.01 sec) When I try to connect remotely from another host, here's what happens:
Setup.exe Xp Pro
how to sort this out everytime i try to uninstall a progarm it comes up with setup.exe has a problem and as to close,it is just on 1 program it is a ebay toolbar im trying to get rid off any help might help.
New Db Setup
Does anyone know of a good web site that I can look at that will show me how to set up a MySQL instance?
DB Setup
I'm trying to figure out how I should layout a database table(s). What I would like to do is be able to keep track of how many times several pages are viewed each day. For example, I'd like to know how many times the index.php was hit on Sept 8. and how times on Sept 9. How many times article.php was hit on the 8th and on the the 9th etc.
Mysql Setup
I am working on setting up a postfix email server with Currier IMAP and Mysql with a squirl mail front end. I am currently having difficulties with the mysql end of the process. I am installing using the source, not the rpm package since i want to get a feel for how to do this way, and I have been unsuccessful at running: ./mysql start the error i get is Can't connet to local MySQL server through socke '/tmp/mysql.sock' (111) Also, according to the install readme, I need the client access libraries. I have been out to mysql's website and I have been unable to locate these files. I have found a tag that will setup only the client access files, --without-server but i'm not sure if this will not allow me to setup both the libraries and the server with an additional tag.
Perl Setup
i have installed Mysql 3.23.49 and Perl 5.6.1.629 on a Win XP Pro..but i can't seem to get my cgi (perl script) to open or use "use DBI" or any perl modules... ...my main proble is that my cgi can't locate perl modules used for Mysql and Perl..i have already tested perl and Mysql individually and have run perfectly.
I CAN'T RUN SETUP.EXE OF MYSQL
I downloaded mysql-4.1.22-win32.zip and I run the setup.exe of mysql but the install stopped because it show to me the windows installer with parameters and do nothing.
Database Setup
I would like to get some suggestions on how to setup my database. I am reading thousands of different tags from a field device. I am reading each tag values at different intervels. I will have a column for each Tag name containing the read value and a column for the date/time stamp. If I put all these tags in the same table I will have rows with one value and the rest null values time stamp | test1 | test2 | test3 | ------------------------------------------ 02/16/05 9:44:44 | 2.45 | null | null | 02/16/05 9:44:45 | null | 3.22 | null | 02/16/05 9:44:46 | null | null | 212 | 02/16/05 9:44:44 | 3234 | null | null | 02/16/05 9:44:45 | null | 3434| null | 02/16/05 9:44:46 | null | null | 2333 | 02/16/05 9:44:44 | 2 | null | null | 02/16/05 9:44:45 | null | 4444 | null | 02/16/05 9:44:46 | null | null | 2121 | But if I make one table per tag I will have thousands of tables. Does anyone have a sugestion?
MAC OS X Setup With PhpMyAdmin
I am having a problem setting up the config.inc.php file in phpMyAdmin. I have amended the mysql user account in Mac OSX in NetInfo and given it a password. I have amended the config.inc.php file control user to the same settings, but I keep getting the messsage 'Access denied for user mysql@localhost using Password: Yes) I have tried all sorts of combinations of user names and passwords for control user and user and the only one I can get to work is user = root with a blank password and controluser name and password of blank, which gives me a warning that MySQL is running with the default privileged account which is a security risk.
How To Setup A Rolodex?
If im creating a rolodex to contain unique id#, names(first, last), adresses(street1, Street2,city,state,zip), phone numbers(home, work, cell) e-mail adresses(home, work), Comments How would this be organized? Would i only use one table or multiple tables? How would i set up each column. (Name, Type, Null,Key, Default,Extra)? Could someone organize this for me. I am trying to learn PHP and MySQL but i just havent figured out the database design part yet and i want to create a rolodex for my site.
MySQL Setup
I have a Windows 2000 Server preinstalled with mySql, and have tried to run a basic connection test though the ODBC manager for the mySql Server Driver, and it continues to say it can not find mySQL. When setting up a standard database through the ODBC Manager, here is the basic info it provides. Code:
Table / DB Setup
I will potentially have 1-3 tables that may be written too 1,000's of times per second. Eventually becoming very very large tables. What methods and suggestions would you make on how to properly handle a task of this nature? I need to be conscerned about performance on pulling many records back as well for statistics.
Setup Under Windows Xp Sp1
I need to upgrade my current mysql installation . But now there is a problem to run the setup.exe of installshield 5.x under windows xp sp1 or sp2. The program hung after few seconds. In the memory remain active woexec, ntvdm and setup, but the process is freezed. It is possibile to convert the current setup mode of mysql4.014 in other install system, as for in mysqlcc092 ?
Database Setup
I'm trying to install a PHP and MYSQL web app which needs me to setup the correct fields. Server Name localhost Database Name mysql Database User Nameroot Database Password MyRootPassword I enter all of this information and I get an error back that says: 'unable to connect to the database server - verify settings and ensure database is running.' Does anyone know what I'm doing wrong??
Table Setup
I have one database with two tables. One is named users, and other is named posts. User table contains this fields UserId(key) Username When user writes a post it is stored in Posts table with this fields Post Table contains this fields PostID(key) UserId Post Now, this is really simple question, but is that a proper way to store posts made by user, so that userId gets stored as well as PostId? I read a bunch of stuff, and this is how i figured it goes, so if you have experience with creating more tables and on a way how to join them together,
MySQL Setup
I've downloaded the mySQL files from the http://www.mysql.com website, and have unzipped them into my c: drive, although, i wish to be able to use this in addition in my PHP programming with my Apache Server. How would I do somthing like this?
Table Setup
I need to track settings on my system on a per directory and per user basis. In this case,I am refering to directories that all users can see and sort. I would like user A to be able to sort the same directory as user B and have their sort choices be independent. So my table needs to have at a minimum: userid: varchar directory: varchar sortmethod: int What table type should I choose? What Indexes should I have?
My.ini File Setup
I want to make sure my ini file is set up right. I have now" #This File was made using the WinMySQLAdmin 1.4 Tool #1/14/2004 11:13:21 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/APPS/MySQL #bind-address=192.168.0.100 datadir=C:/APPS/MySQL/data #language=C:/APPS/MySQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/APPS/MySQL/bin/mysqld-nt.exe user=X3Graphics password=xtreme" What I want to be able to do is update my database locally and on my hosting server. Is this possible.
Hardware Setup
We are working on a CMS system using PHP and MySQL on a Apache webserver which will be a local setup. We are today 7 employees at the office and plan to run this system for another 10 in a year from now. So, we are looking at approximately 20 to 25 users as a total. We have already decide to go with a Windows 3000 server environment but we are not sure what type of hardware setup we need for our purposes.
Setup Program
I'm writing a Java setup program for installing a JDBC app, which connects to a Mysql database.I want to create a script in order to provide final user setting privileges in that database and add it a table, without needing to write Mysql commands. How can I do it ?
Setup Table
I'm working on this script where users can add another users to their friends list. Basically, user add another user as friend and must be approved by another user in order to be called friend. The problem is I don't know how to setup a table for this.
Setup Database
Wanting to set up where users can set up a buddy list where they click on a username and send a request to said user to place them on their buddy list. Also want to have a list of users that are on this buddy list. Currently have but a single table with this structure id SMALLINT(6) username VARCHAR(40) password VARCHAR(40) user_invite VARCHAR(40) grant_request ENUM ("yes","no") friends VARCHAR (40) I am by no means any good with setting up a table or table that would work properly with MySQL, so any suggestion as to how to set up a workable table structure that would easily be updated when users request from other users to allow them to be added to their buddy list.
Db Password Setup
I use phpMyAdmin to change db password, but failed. It says: SQL-query : SET PASSWORD = PASSWORD( '*******' ) MySQL said: You must have privileges to update tables in the mysql database to be able to change passwords for others
MySQL Setup
I'm going through the PHP/MySQL tutorial on Webmonkey, and I got to the part where we create a DB - I'm getting this error though... C:MYSQLBIN>mysqladmin -u root create mydb MYSQLADMIN: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' ( Check that mysqld is running on localhost and that the You can check this by doing 'telnet localhost 3306'
MySQL Setup
i got my Apache and PHP to work. only problem is mysql. i just cant get it to work. my localhost is http://localhost:8080. whenever i try to create a database i get the following error: Access denied for user: '@localhost' to database 'customers' should mysq be using the same port (8080) as my apache server. right now mysql is using 3306. its a winXP system.
Verifying Setup
I am new to mysql as of yesterday, however i have a fair amount of sql server experience. I have configurable webservices(written by a coworker) that should be able to connect to sql server or mysql. I can configure and test on sql server no problem, however when connecting to our mysql server it is failing to connect to the database. Is there a simple way to test my database connectivity to ensure my passsword and UN and connection string are appropriate?
Database Setup
I have Installed MySQL on my server. I am trying to install a forum. I have no idea where I can find the Database NAME. that I type in the PHPBB installation script. can anyone tell me how I set a database name?
Setup Password
I have been trying to set up mysql on os x 10.4 tiger. Everything went well. I had a test php page. When I completed the setup of mysql I ran the test page and everything worked a treat . I had been following a tutorial, a wee bit out of date, but all good. It recommended that I give mysql a password like the root on the apple. So, I did: mysqladmin -u root password new_password_here It seemed to take it ok, i.e. didn't print an error message or anything. So, I thought all was well , but when I went back to the test page (after editing it and providing the new password details), I got an error : Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in /Library/WebServer/Documents/test.php on line 5 Warning: mysql_select_db(): Access denied for user 'root'@'localhost' (using password: NO) in /Library/WebServer/Documents/test.php on line 9 Warning mysql_select_db(): A link to the server could not be established in /Library/WebServer/Documents/test.php on line 9 Access denied for user 'root'@'localhost' (using password: NO)
Question About MySQL Setup On A Mac
I'm a fairly experienced web designer, but a newbie to PHP/MySQL. I have the Sitepoint book by Kevin Yank called "Build Your Own Database Driven Website Using PHP and MySQL" and I'm ready to start learning! I already have a mySQL db setup through my web host and I can access it using PHPMyAdmin via the web. However, the book recommends (and gives instructions for) setting up Apache, PHP, and MySQL locally and says that for learning purposes it is better NOT to use PHPMyAdmin. I hear that, but at the same time, for security reasons, I'm not all that hip on turning on Personal Web Sharing and making my computer into a server. It seems to allow access to my Sites folder which is where I have my local copies of sites I'm working on and I don't really want anyone else to access those... I'm hoping someone here can tell me which way to go... is using PHPMyAdmin really going to hamper my learning experience, or should I just use it (and feel safer)? Or are my security concerns really not that much of an issue? If anyone can give me any guidance on this, much appreciated.
Is This An Efficient MySQL Setup?
I would like to offload the MySQL server from my dedicated box in order to speed up page loads. I don't have an additional dedicated server so my only option is to get a VPS. But is offloading the MySQL server to a VPS, albeit a modest one, even worthwhile? I understand this is a very broad question because I am not providing any details but that being the case I am expecting a broad answer
|
TRACKER
