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:

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 co

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 der

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 abc

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 "Great spirits have always encountered violent opposition from medioc

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 t

users and passwords...users and passwords...

NEWBIE QUESTION Hello, Just installed mysql on a solaris2.7 sparc machine, but I don't seem to have permission to do anything! I add a user by typing useradd username BUT HOW DO I SET THE PASSWORD? Someone suggested doing this: mysql>insert into user (host, user, password) values ('localhos

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 calle

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 gre

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

laris (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 thi