Mysql.com manual

Hey Everybody, I noticed that a lot of people experience problems when they try to start the mysql server by typing this: $ bin/safe_mysqld --user=mysql In the Mysql/msql O'Reilly book, it says to type this to start the daemon: bin/safe_mysqld --log I ran into problems with the first

Re: Cannot gain access to MySQL server

Brian, When you run the mysql_install_db bit, a root user is created (username = root...imagine that!) But, there is no password for this root user. You have to set this password yourself. Here's how to do it: 1. $ bin/mysqladmin -u root -p password 'enter_new_password_here' Then, try this:

DBI access from CGI script

Hey all, Using a CGI script, I want to access a database from A DIFFERENT server than the mysql database is hosted. What is the proper syntax to access the mysql database on a different server? They're 2 levels of secruity: 1. Log into Telnet shell 2. Log into database This is what I have

DBI:mysql error message

Hey everybody, This is my perl DBI script: #!/usr/bin/perl -w use DBI; $username = myusername ; $mypassword=mypassword ; my $dbh = DBI-connect(DBI:mysql:table1:localhost, $username, $mypassword); die Can't open DB\n if (!defined $dbh); my $sth = $dbh-prepare(SELECT * FROM abcpro) or die

DBI:mysql

Does anyone know the correct syntax to connect to a mysql database with DBI? I tried the syntax mentioned in the Perl DBI O'Reilly book, but I got errors. thanks = # Simon K. Chan insert important-sounding title here Great spirits have always

Mysql Root User (super user)

In 6.13 of the mysql manual (Setting up th initial Mysql Privileges), it mentions that the Mysql root user is created as a superuser who can do anything. The Initial root password is empty, so anyone can connect as root without a pasword and be granted all privileges. How is this mysql super

'Can't find file: './mysql/user.fr

I get the following message: $ mysqladmin -u root password 'newpassword' mysqladmin: unable to change password; error: 'Can't find file: './mysql/user.fr m' (errno: 13)' I think I may have run scripts/mysql_install_db twice! (never work on a computer when you're half asleep!) Could that be

libexec

When I run the safe_mysqld, I get the following error message: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. I don't have a folder

PATH

Hi Everybody! I'm installing Mysql on a solaris 2.7 sparc machine. In the mysql manual is this passage: You will find several files and subdirectories in the mysql directory. The most important for installation purposes are the `bin' and `scripts' subdirectories. `bin' This directory contains

purpose of groupadd and useradd

Hi Everybody! Installing Mysql on a sparc sun solaris 2.7 machine. The manual from msyql.com mentions adding user and group. What's the purpose of this? Thanks for your help! __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great

Hmmm. Error message...

Hi Everybody! Anyone with any idea what to do I get this error message: ERROR 2002: Can't connect to local MySQL server through socket '/usr/local/common/mysql-3.23.33/data/mysql.sock' (13) H. Thanks for your time and advice. Simon

getting started...the hardest part

(Sparc)[sun-soalris2.7-sparc] ) what exactly is the "GNU Tar" command? How do I install mysql with it? Any help would be much appreciated. Many thanks everybody! Sincerely, Simon Chan __ Do You Yahoo!? Yahoo! Auctions - buy the thing