Virtual Server?
i read somewhere that you can setup virtual mysql servers, so that users can actually have their own sql server to administer with whatever databases they want to create, with out interferring or even seeing other peoples databases. Does anyone know how to do this? could you help me? jason http://mrtg.whitetec.com
Dates
i have noticed something, i have ported some asp, and visual basic applications from MSSql to MySql, and i have noticed something with the dates, i have to change my entire date format. Does anyone know how to set the way dates are interpreted in MySQL? jason http://mrtg.whitetec.com
Re: Need your helps!!!
i read somewhere that in version 4. or whatever one of the next versions will be, that they are talking about doing the ability for bi-directional replication. i have been trying to do the same thing - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: Simon Green [EMAIL PROTECTED]; 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 6:33 AM Subject: Re: Need your helps!!! No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the manuals about this. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 17:58 Subject: RE: Need your helps!!! Have a look http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat It is all about what you would like to do. Simon -Original Message- From: chen jun [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 10:52 To: [EMAIL PROTECTED] Subject: Need your helps!!! Hi There: I want to establish several mysql servers which can synchronize data each other(if data of one server is updated,the others can be updated too). I don't know if it's done and how to do this. Need your helps. Regards, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question
i have designed a system that works on MSSQL but i have decided to port it over to mysql. One of the problems i have come across is i need to figure out how to get the autoid back. so just say i insert a record, and MYSQL gives it the auto id of 6, how do i know that from my VB program? Jason
Replication
i was wondering if anyone could help out with some replication stuff. i went through the instructions from mysql.com and when i restarted the slave, it said that it was not configured correctly.
Re: Connecting to MySQL w/VB
i know i am definitly knew at this, but his permissions could be set more or less for read only. i am just spitting junk out, i am new, but i don't like sitting idle in a group. i have been watching this thread closely, because i do developement on a large scale in ASP and VB. so just ignore me if i am being an idiot. Jason - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 11:03 PM Subject: Re: Connecting to MySQL w/VB - Original Message - From: Robert Skinner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 7:44 PM Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? A bit more information might help us help you. If you the db reads work fine, then you at least have the connection made - that's already half-way there! I have done extensive work with MySQL and VB/VBScript, but if you can execute a SELECT query (as your e-mail indicates) I don't see how you would have problems executing an INSERT query (assuming the SQL statement is valid). What exactly seems to be the problem? Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL w/VB
just curious, how do you connect to mysql through ASP? i have tried connecting with MyODBC, i installed myodbc and then i create the connection string in asp like this set conn=server.createobject(adodb.connection) conn.open driver={mysql};server=192.168.0.1;user=user;pass=pass;database=db1 i was just curious to see how you connect to mysql with asp jason asp developer working in mysql :) - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: Jason Brunk [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 11:38 PM Subject: Re: Connecting to MySQL w/VB - Original Message - From: Jason Brunk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 8:18 PM Subject: Re: Connecting to MySQL w/VB i know i am definitly knew at this, but his permissions could be set more or less for read only. Yes, it's possible that the permissions are not set properly. However, I was assuming that, since he had just started working with MySQL, he was using the root account, unmodified, which would give him complete access. It's been my experience that it is much easier to work with ASP MySQL than VB MySQL because of the databound objects, and wouldn't be surprised if the problem that the original poster has does not apply to ASP. Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Installation Help Requested.
is there anyone who icq and who has a few minutes that might be willing to help me out with the mysql install? i have been having some trouble, so i figured i would check and see if there was anyone who could help a newbie out. Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Installation Help Requested.
i originally tried to do it with the /stand/sysinstall on bsd, and it installs it fine, but i am using the program MySQLFront to try and access it, and it keeps coming up Host perm202-202.ij.net is not allowed to connect to this mysql server the host name perm202-202.ij.net is host of my workstation since i am on a static ip, but i used grant all privileges on *.* to jbrunk@% and it goes into the user table of the database mysql, and shows that the host that jbrunk is allowed to connect from is % but it won't let me connect from mysqlfront Jason - Original Message - From: Peter Matulis [EMAIL PROTECTED] To: 'Jason Brunk' [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 2:12 PM Subject: RE: MySQL Installation Help Requested. From RPM, binary, or source? I have my personal docs for source. Peter Matulis 282-7073 ext 392 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Jason Brunk [mailto:[EMAIL PROTECTED]] Sent: June 27, 2001 12:43 PM To: [EMAIL PROTECTED] Subject: MySQL Installation Help Requested. is there anyone who icq and who has a few minutes that might be willing to help me out with the mysql install? i have been having some trouble, so i figured i would check and see if there was anyone who could help a newbie out. Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie
hello all, I am kind of new to all the unix OS stuff. Lately i have been doing alot of work in FreeBSD, and i have started playing with mysql. I got it to install and everything, the only problem i am having, is i can't seem to connect from anywhere off the machine, i run the grant privileges on command and it says 0 rows effected. i was wondering if i may be doing something wrong. any help would be appreciated, thanx Jason