Re: Sql 5 new installation and root password?

2008-03-01 Thread Jørn Dahl-Stamnes
On Saturday 01 March 2008 13:45, Jørn Dahl-Stamnes wrote: > I have just installed MySQL 5. The server is running, but I'm not able to > connect to the server as root. > > I have not set any root password, since I have not found any way to do this > in version 5 (it was rather good documented in ver

Sql 5 new installation and root password?

2008-03-01 Thread Jørn Dahl-Stamnes
I have just installed MySQL 5. The server is running, but I'm not able to connect to the server as root. I have not set any root password, since I have not found any way to do this in version 5 (it was rather good documented in version 4). I have tried this solution to set the root password, bu

Re: Problems connecting using "-h hostname" with new installation

2006-08-07 Thread Daniel da Veiga
On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote: Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the foll

Re: Problems connecting using "-h hostname" with new installation

2006-08-07 Thread obed
On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote: Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the foll

Problems connecting using "-h hostname" with new installation

2006-08-06 Thread Ro BGCT
Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the following message: "ERROR 1130 (0): Host '75.1

User Account errors on new installation

2004-02-13 Thread Russ Myrick
I have MySQL ver. 4.0.18 binarys for windows installation.  I just finished installing mysqld-max-nt as a service on a WinXP box yesterday afternoon.  Using the MySQL Administrator client/utility GUI, I configured the anonymous and root Users, then added a superuser level account for myself. 

A newbie is having troubles starting mysqld on a new installation of version 4.01

2002-06-30 Thread MySQL server
>Description: I think that when I installed mysql, I ran out of room on the /var file system >How-To-Repeat: bash-2.05$ /usr/sbin/mysqld --datadir=/home/mysql InnoDB: Error: data file ./ibdata1 is of different size InnoDB: than specified in the .cnf file! InnoDB: Could not open data files 020630

RE: Problems With New Installation

2001-12-24 Thread Ben Ocean
; >-Original Message- >From: Ben Ocean [mailto:[EMAIL PROTECTED]] >Sent: 24 December 2001 17:40 >To: [EMAIL PROTECTED] >Subject: Re: Problems With New Installation > > >I forgot to mention that /var/lib/mysql is owned by root and I'm in as >root. I've also c

RE: Problems With New Installation

2001-12-24 Thread Matthew Smith
mysql_install_db in the scripts directory? This installs the database 'mysql' which contains all user authentication. M -Original Message- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: 24 December 2001 17:40 To: [EMAIL PROTECTED] Subject: Re: Problems With New Installation I

Re: Problems With New Installation

2001-12-24 Thread Ben Ocean
I forgot to mention that /var/lib/mysql is owned by root and I'm in as root. I've also changed permission to mysql ownership of said directory with no luck. Any ideas? At 08:31 AM 12/24/01 -0800, you wrote: >Hi; >I've successfully installed mysql from source. However, I've run into a >problem

Problems With New Installation

2001-12-24 Thread Ben Ocean
Hi; I've successfully installed mysql from source. However, I've run into a problem with trying to create databases or users: mysql> create database cc_store; ERROR 1006: Can't create database 'cc_store'. (errno: 13) Furthermore, I can't edit the root password. What fundamental step have I mis

new installation

2001-08-03 Thread Mark -None-
I downloaded, compiled, and installed the latest MySQL release from the source code at www.mysql.com last night. I was running through the tests documented in the INSTALL-SOURCE file, and I've found that mysqladmin -u root shutdown does not work. I've done a ps and I can still see the mysqld r

Re: new installation

2001-08-03 Thread Michael Collins
At 1:07 PM -0700 8/2/01, Mark -None- wrote: >I downloaded, compiled, and installed the latest MySQL release from >the source code at www.mysql.com last night. I was running through >the tests documented in the INSTALL-SOURCE file, and I've found that >mysqladmin -u root shutdown does not work.

core dump on new installation

2001-07-03 Thread sdb
>Description: ./scripts/mysql_install_db fails on a new installation with: Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table longjmp bo

Can't create a user on new installation

2001-01-17 Thread Paul Van Deusen
This is my first use of mySQL, so forgive my ignorance. My problem is that I am not allowed to do anything as the new user I just created. The mysql utility refuses to allow access. Note that I did run "mysqladmin reload" after granting privileges. I have the mysql daemon running. I've crea