reset lost root password

IS there a way to reset a lost mysql root password? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql command line error

Hi there - I am trying to issue the following command in a terminal window... I know my syntax is slightly off, however I can not see what... it seems to be due to the OLD_PASSWORD function... any pointers? mysql -u${DB_NAME} -p${DB_PASSWORD} -eGRANT select, update, insert, delete ON

Re: mysql command line error

Sorry - but to add to this, the command is actually in a bash script. I suspect it is the single quotes and or the () characters Dustin On 24-Oct-05, at 11:57 AM, Dustin Krysak wrote: Hi there - I am trying to issue the following command in a terminal window... I know my syntax

Re: mysql command line error

I got it figured out.. of all things it was a line return. DOH! Dustin On 24-Oct-05, at 12:14 PM, Dustin Krysak wrote: Sorry - but to add to this, the command is actually in a bash script. I suspect it is the single quotes and or the () characters Dustin On 24-Oct-05, at 11:57 AM

multiple commands to mysql from regular command line

Hi there, I was wondering if it was possible to issue multiple commands to mysql from a regular command line? For example i know you can issue a single by the following: mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases' Now what if for example i needed to select a database, then run

Import from excel to MYSQL

Is there an easy way to get an excel spread sheet imported into a MYSQL database? Any links to a tutorial? Thanks in advance! Dustin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

**field type for large amount of text***

What is the best field type to use for a field that will be used to display a large amount of text (and possibly numbers) IE a field that will display the main text for a web page. Thanks -Dustin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Refusing connections?

Ok, I have posted some things like this yesterday, but I have some new things to add... Yesterday I made a posting about having issues connecting my coldfusion to mySQL. Well I am pretty sure I have narrowed it down to mySQL being the issue... (NOTE - mySQL and CF are on the same server) The

Setting to allow remote connections?

Is there a setting that I must change on a MYSQL server to allow remote connections from a GUI client? I can only connect when I am local Thanks! .::d::. • --- THEbeatingsWILLcontinueUNTILmoraleIMPROVES --- • -

Setting to allow remote connections?

Is there a setting that I must change on a MYSQL server to allow remote connections from a GUI client? I can only connect when I am local - To add to this, the error I am getting is: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused

Syntax to create admin user for a database

Hi there, I am still having issues creating a user that can access a database. The only time the user can access is if I SSH into my linux box (redhat 8) and connect with: # mysql -u id -p It works fine when doing that, and I can create and do everything I need to do. Now - I am trying to

Error in mysqlcc

Hi there - I have a database and I am using mysqlcc to admin the mysql server. At anyrate - when I am connected and I am trying to create a new table, and I get the error: Could not load Field Types. Please select the location of the Syntax File in 'Options-General-Sql Editor' and re-open this

Connection error

Hi there - I'm truing to connect to a mysql server (redhat linux 8) with the mysqlcc GUI (through a SSH session), and for some reason when I try to connect I get the error: [localhost] ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Now I was reading that