RE: Re: Re: Access denied @locahost

Just jumping in here so take this info accordingly. Do you have root access to this machine? If so, try restarting with --skip-grant-tables and set up your perm scheme. Look into mysqlaccess what does it say for root localhost ? You can also replace user, host, db with '%' to see all

RE: mysql /var dir

You could look into parted to resize partitions or copy the db to the desired directory and restart the damon with safe_mysqld --data-dir=/where/u/moved/db/to. I believe you'll also need to copy over the mysql database to the new location as well or mysql will fail to start. first, note your

RE: How to access mysqladmin from IE?

If you installed correctly and it's running then you likely forgot to add the '/' at the end of the phpmyadmin part i.e. youriphere/phpmyadmin/ not yourip or localhost/phpmyadmin. justin -Original Message- From: Aqua [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 7:42 PM To:

deleteing data from a row

How do I delete data from a table? I tried the man pages for delete and replace but there not working. I have a table with 8 rows. The table is called properties. The row is called bulletpoints. i tried deleting and replacing the fuged data and sql says ok bla but when I select bulletopints

RE: deleting data from a row

it in notepad before I copy it over into my insert into properties (bulletpoints) values ('paste from notepad'); Maybe there's a better way since the above seems cumbersome. Regards, justin -Original Message- From: justin cunningham [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 12

RE: new to mysql, what did I type wrong?

Try 'mysqlaccess root localhost' and see if there is a password set in the output. Try man mysqladmin and set the password there. If you've hosed your perms then stop the damon and restart it with --skip-grant-tables and start again. Remember to do mysqladmin reload or flush privileges

RE: mysql -u is not working for me today but was yesterday

I've sent similar questions to the list with no replies so here's the best I can do for you. I use debian so I dunno what's specific to it beyond the created user to start and stop the damon so; try mysqlaccess user host db to see what privileges you've got. u can restart msyql or

RE: changing column name

I believe that's modify. Check man page. Alter table yourtablename MODIFY yourfieldname varchar (25) (or whatever ) not null default 'no comment' -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 7:37 AM To: MySql Mail List Subject: changing

what causes this error

mysqladmin: CREATE DATABASE failed; error: 'You have an error in your SQL syntax near 'whateverunamethedatabase' I can complete every function with msyqladmin except create and drop. What am I doing wrong. I've read all the docs online, sent similar emails with no response. This is not an

RE: what causes this error

this error Justin, The error message states that you have a syntax error in the CREATE DATABASE statement. This is probably just a typo, but the only way for us to diagnose the problem is for you to post the exact statement that gives you the error. -myk justin cunningham wrote: mysqladmin

RE: what causes this error

exactly.mysqladmin -V mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686 this and every other command in mysqladmin work except for create and drop. dunno why. I'd like to get on to building databases instead of permissions over and over. I ssh into the box. User/pass are

RE: what causes this error

this is the version packaged with the stable branch of debian. Thanks, justin oba:~# mysql -V mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686) oba:~# mysqladmin -V mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686 oba:~# mysqladmin ver mysqladmin Ver 8.19 Distrib 3.23.37,

RE: what causes this error

Thanks! I'll choose option A since i'm being paid to build a database (now I'm behind;( not reinstall sql and debian's woody will be pushed into stable soon (along with mysql-server 3.23.49-8 etc which is the point of going with debian). Thanks again! -justin -Original Message-

example connecting to database via socket instead of networking

Hi list, can someone here give me a quick and dirty example of how there connecting to a database via sockets? I see the data in the man page but I'm uncertain as to implementation. Thanks, justin Sql,query - Before posting,

first mysql table; syntax qustion

Hello list, this is my first table for a simple php page and I'm hoping someone could briefly review its structure. The only fields I'll be sharing are property_name and type. Are they set up properly for select join queries? thank you, justin Database=properties Tables are

RE: first mysql table; syntax qustion

Thanks for the reply! Should I change the structure such that all varchar fields are in the same table? I believe you did understand my design correctly. Available_properties contains the primary data. Property names is just a table that contains subsequent data for available_properties and

mysql user perms failing at login

I created two users with grant; obdba with select,insert,index,file and other privileges and obdbu with select only privileges. Flushed privileges. Mysqlaccess shows the correct perms for database 'properties' (the only database) for each user although when I try logging in as either user to