Permission Problem in OS X
I am having a problem with accessing the mysql database in a new MySQL installation on OS X Panther. This installation came with the original OS, and some configuration was done right after installation. I have previously installed MySQL on Linux and Win and have never encountered this problem. After being unable to log into MySQL at all, I decided to reset the MySQL root password. I did everything according to the book (several of them): - kill mysqld by killing host.pid - restarting mysqld --skip-grant-tables - reset password for root by using MySQL client - Flush Privileges - restart mysqld the normal way. Over the past 2 days I have done this many many times. In between the steps I always check the processes to confirm that the previous step took. With the grant tables skipped I am able to access the mysql db just fine. After flushing privileges and restarting without skipping I cannot connect to the mysql db with either of the usr/pwd combinations I just created. I have tried back and forth - with a my.cnf file in /etc and without. With the client password set in that file and without. I am doing everything with the root password in OS X enabled but logged in as a non-root user. Where It's needed I am using sudo. Is this where the problem is? the password for OS X root and MySQL are different, and the MySQL password does not contain any reserved letters. It strikes me that, after going through all of this, and as a non root user, the graphical MySQL Manager refuses to stop the database without giving me an error message. # mysqladmin -u password password has not worked in any scenario, whatever I do. I am getting really sick of this and have exhausted my ideas after going through several manuals. Can somebody please help! Thanks! Dietrich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DSNless connection from ASP to Linux
I am trying to to use a DSNless connection from an ASP script( on IIS5) to a MySQL db on Linux. I am trying this: strConnection=_ driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o ption=NUM Set adoDataConn = Server.CreateObject(ADODB.Connection) adoDataConn.Open strConnection strQuery = SELECT * FROM user; Set RS = adoDataConn.Execute(strQuery) -- and am getting this back: -- Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /mysql.asp, line 7 --- Can somebody tell me what I am missing, please! What do I need to install on the server in order to make this work? The odbc connection works fine. Thanks Dietrich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DSNless connection from ASP to Linux
I am trying to to use a DSNless connection from an ASP script( on IIS5) to a MySQL db on Linux. I am trying this: strConnection=_ driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o ption=NUM Set adoDataConn = Server.CreateObject(ADODB.Connection) adoDataConn.Open strConnection strQuery = SELECT * FROM user; Set RS = adoDataConn.Execute(strQuery) -- and am getting this back: -- Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /mysql.asp, line 7 --- Can somebody tell me what I am missing, please! What do I need to install on the server in order to make this work? The odbc connection works fine. Thanks Dietrich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Random ID creation in MySQL /Linux
Hello: I am trying to find a way to create a random ID for use as a session ID in a MySQL table. In MS SQL I use NewID(). Does anybody know an equivalent to use for MySQL, running on RedHat Linux 8.0? I'd be greatful for any tip. thks! Dietrich - 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 - Where do I look for answers?
I am a complete newbie to mysql and Linux. I completed the installation of the 4.0 version of MySQL/InnoDB, and now I am stuck with permission problems: Logging in with empty username/password lets me look at the initial state of the db, but creating new users or new tables through any front end fails with permission problem messages. SQL (MS-SQL) is second nature to me, but this is not. - Where do I find an EASY, straight forward manual about MySQL administration on Linux - As the root user, how (and where) do I create new MySQL users, set permissions correctly? I would be very greatful for any help Dietrich - 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
Front end won't connect
Question from a Linux and MySql newbie I just installed RedHat 8.0 and MySQL. During installation there was no prompt for any database server properties (hostname, user). Now I downloaded MySQLCC and try to configure the connection to the server. I assume the server is running, because I can start and stop it through the services interface. However, whatever info I put into the Client - it will always give me an error 145 (User can't connect). What am I doing wrong? I followed the instructions in the INstall file to set up a new user and got an error also. I guess that's what happens when a MSSQL guy, spoilt and unnerved by endless wizzards, tries to learn Linux. Dietrich - 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: E-Commerce, db-clustering and MySQL?
Hello Bjorn: Thanks for the encouragement. There are a lot of questions I still have, though. I am constantly working on moving the sql code into stored procedures in order to improve speed. I'd like to keep asp on 2000 servers. Doesn't the lack of stored procedures force me to go back to parsed queries on the site? And am I right thinking that that would be a big step backwards? We're talking more than 100 stored procedures and tables with up to 750.000 rows. But it sounds like it's doable . DIetrich - Original Message - From: Björn Pålsson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 08, 2002 3:14 PM Subject: Re: E-Commerce, db-clustering and MySQL? First, I wish to say that you are making the right descision leaving M$ and taking a step into MySQL. Currently, I'm working on a project involving +500.000 rows and estimated 30.000 visitors / day on a 2 x dual 2.8 GHz Xeon dedicated for SQL. Additional servers are for HTTP and other tasks. There will be a lot of load on the SQL when the users searches our database on either category, area or on a fulltext keyword. The key to managing thousands of visitors is to have a system setup to minimize the number of querys and managing the traffic between the diffrent machines. We will use a second gigabit-switch and a secondary net on the 10.0.0.0 to unload our primary public switch. We also have pre-cached pages with the most popular products/listings. In our case, the visitor may input data and therefore he will trigger a re-cache. A separate machine is used for this purpose as this may happen very often. To make a user allowed to input data you must setup the servers in a ring with each server acting as both master and slave. If you have a clean system with very few inserts/updates you may choose a simpler solution with a single master an several slaves f.x. if the only insert is in the checkout in a webshop. If you have click counters, this simple solution will fall. If you have the ring-solution, you must make shure your script never makes any contradicting inserts. Use auto_increment if possible when inserting and/or use your session-id as an identifier. Always use relative updates when you must update a value. Do not write SELECT count from article WHERE id = '$id' $count++ UPDATE count set count = '$count' WHERE id = '$id' but use UPDATE count = count + 1 All these things to think about will force you to dig deep into your script and if you have a script-in-a-box solution from a third party coder, you are definately in a difficult situation. If you know your script well, you will have an easier task. Please tell me about your future findings! Greets Hello: We are running a large e-commerce site currently with ASP/MSSQL. The ever increasing number of hits, complexity of the site and request for reporting is slowly but surely bringing us to the point were the current database application is getting tired. Now we're thinking Linux, MySQL and clustering. I have been looking around a little and don't like the fact that there are no stored procedures and no triggers. However - if we cluster several quad processor machines we should be fine without. Right now it's all theory, and there don't seem to be a lot of articles on the web about this. At least I had no luck finding any. Does anybody have real life experiences with this kind of a setup? Does anybody know where to find reports about this? I'd be greatful for any link or hint! Dietrich Speer - 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
E-Commerce, db-clustering and MySQL?
Hello: We are running a large e-commerce site currently with ASP/MSSQL. The ever increasing number of hits, complexity of the site and request for reporting is slowly but surely bringing us to the point were the current database application is getting tired. Now we're thinking Linux, MySQL and clustering. I have been looking around a little and don't like the fact that there are no stored procedures and no triggers. However - if we cluster several quad processor machines we should be fine without. Right now it's all theory, and there don't seem to be a lot of articles on the web about this. At least I had no luck finding any. Does anybody have real life experiences with this kind of a setup? Does anybody know where to find reports about this? I'd be greatful for any link or hint! Dietrich Speer - 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