MYSQL :: Setting Password

Setting Password
i've created my database and now i want to access it through php so im using:

mysql_connect('localhost:3306', "username", "password") or die(mysql_error());

but i haven't yet set a password and don't know how to, so when i run the file it comes up with the error:
mysql_connect() [function.mysql-connect]: Access denied for user......

is this because i need to set a password and username,if so then how? or is it maybe another different problem?

Setting Mysql Password
How do I set the mysql password? Are there separate password for every database I create?

Setting User Password
I am having a problem getting mysql to recognize my user password. Currently I am doing everything on 'localhost' [CASE]

My root password works; I have access and can create databases as root.

I used MySql Administrator to create a user 'bill' and gave that user a password (billpw) different from root and applied most of the global privileges including 'CREATE'.

I can open mysql with root and rootpw. As well, I can open mysql with user 'bill' and rootpw but NOT with billpw.

[bill@CASE ~]$ mysql -u bill -p
Enter password:
ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)

Even when I open Mysql with bill rootpw, I get the following:

mysql> CREATE DATABASE menagerie;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'menagerie'

I can CREATE the DATABASE as root.

I have read Section 5.7, â€œThe MySQL Access Privilege Systemâ€ and nothing seems to apply -- but that could just be newbie ignorance.

Do I have some Linux permission problem related to MySql or have I done something wrong when creating my user ? How can I check for the error?

Setting Up Password Fails
Having a problem setting up a password for MySQL

The reported problem when attempting to set up a root password is;

C:mysqlin>mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

When checking this:

C:mysqlin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port
3306: C
onnect failed

Setting Up The MySQL Password
I can't seem to see the page whan I am trying to set up the 'Setting Up the MySQL Password'. I know this is right at the start but all I get when I type in the Web browser http://127.0.0.1/myadmin is the sourcecode and not the actual log in page...

I know it's something silly I have done or not done (I have installed the Apache / MySQL / PHP stuff over and over again, but it still does the same thing to me.

The Apache services is running fine. The WinMySQLadmin is on green so I know that's fine.
I think it's maybe an explorer thing? but I can't seem to get it.

Setting Password Fails
The reported problem when attempting to set up a root password is;

C:mysqlin>mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

When checking this:

C:mysqlin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port
3306: C
onnect failed.

Setting MySql Root Password
I feel a bit daft as I can't seem to get passed p21 of Database Driven Website by Kevin Yank. But I'm learning

Ive got the latest copy and and want to follow it through to see what i can learn (lots I'm sure)

Im on a mac osx and am trying to set the root password. He says to do this using terminal in the bin directory of my MySql installation.

Where is it? i know basics about getting round terminal i.e changing directories and stuff.

Setting Root Password For MySQL
I'm Using the "Build Your Own Database Driven Website Using PHP and MYSQL" by Kevin Yank. On pg. 22 where the arguments new password are in parentheses, I typed in new password instead of my own new password ( I know that was dumb!). Anyway, when I quit the Mysql and start over I get the error: cannot login to local host password not excepted. How do I restart so that I can create a root password for Mysql?

Setting Mysql Root Password
Am having problems setting the root password for the mysql server on my computer. I'm using Mac OS X with apache, php 5 and mysql 4.1 installed. I've tried using the terminal utility but I've had an error message reading:

Setting Up Root Password For Mysqldatabase
I have Fedora Core 4 installed in my pc and I need to setup mediawiki.
In the process of setting up mysql database (to create root password),

I did as instructed, typed -

1. mysql_install_db
2. mysqld_safe

it replies - Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060323 15:22:34 mysqld ended

but when I try to type mysqlshow, it gives this error instead
mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I could not setup the root password for mysql bcos of this error.

Strange Password Setting Behavior In Fedora Core 4 (server 4.1.11)
I have tried adding users aided by several references and this typifies the procedure:

http://dev.mysql.com/doc/mysql/en/adding-users.html

But, I found that after adding them, I could not use them to get into mysql. I found my way to this reference,

http://dev.mysql.com/doc/mysql/en/access-denied.html

and on a hunch, set the password to '', that is, no password at all and find that now I can use them to get in. What is going wrong here? Also, I am finding that I cannot get into my database from a remote host, even though I use the '%' variable or even more directly, the actual 'RemoteHost' name.

Random Password Vs. User Created Password For Site Login
Are there any security issues or other concerns that make one preferable? The client is pushing for user created passwords.

I'm mapping out the basic functionality and front-end for a MySQL/PHP back-end that will be completed by a third party. I'm a novice to MySQL but familiar with PHP and their interaction. Mainly looking for anything to support one method over the other.

Mysql Password() & Unix Crypt Password...
I am creating a user administration system where system administrator
can activate services for a user, like webspace, a mail account or a
subdomain.

I now want to create a function that creates mysql databases and grant
the right privileges to a user. But the problem is that mysql wants to
have the plaintext password for the user in the "grant ... identified by
'pwd'" field, or in a manual query to update the password in the
mysql.user table with PASSWORD('pwd').

I have another database which holds the passwords for the users, these
password are stored the moment a user signs up and are used to activate
services, for example ssh access to the machine. The stored passwords
are encrypted using crypt(). So for adding a ssh service to a user, I
simply do echo "$user:$pwdhash" | chpasswd -e.

I have chosen crypt because some programs (like proftpd) don't take md5
sums.

The problems is that I don't have the plaintext password. So I cannot
add a mysql db.

So I need to create a user in mysql with a crypt password.
I tried to just "grant all privileges ... identified by 'nothing'"
and then afterwards update the mysql.user table and putt the crypt
password in there but it doesn't work like that.

Does anyone have any idea on how I could fix this, how can I create a
user in mysql without having his plaintext password and only having a
crypt hash of it.

I thought about not only storing a crypt hash, but also an md5 hash and
a mysql PASSWORD() hash.. but I think that's an ugly solution.

I Can Connect With Db Password Or Blank Password
I have a password setup for root (% and localhost) in Mysql 5.0.26, I can connect ok no problem. I can also connect with blank password! I know it is checking the password cuz it fails if it's wrong.

I'm sure I have only one account as well (tried to delete, recreate, etc... no change)
select * from user where user='root';
| localhost | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ...
| % | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ...

Is there an option to accept blank password!? I have this problem only for root user; Other accounts are fine.

I Changed Root Password But I Can Not Login With Changed Password
I changed the password of root with
update user set password=password('newpassword')

Then I exited. But when I want to login again , it cannot authenticate the root
I should tell you that a hacker had changed my root password before. Because it was not encrypted before.

Setting Up
Im wanting to set mysql/php on my mac. Im wondering if installing mamp is the same as installing each component seprerately. Can i get away with mamp or should i go through and set it up manually?

Setting Up An ISP
I am trying to figure out how to setup an ISP. I have
broadband in my shop and was thinking, I could setup the house to call into
my network and connect to the Internet through my DSL. I have servers with
Mandrake 10.1 for web/mail/ftp. Was wondering if this could be done and
what needs to be done for it to work?

Setting Up
I need to setup on which directories on my hosted servers. I am a member of a volunteer organization, but would like to have a wiki posting to help promote some of the events that have lower turnouts. Also to get comments and perhaps media from some of the more successful events.

I'm very new to this and am still reading up on some reference materials, but would like to have something tangible to work off of. Our budget is limited as well so I opted for the low budget plan for now, so I am still uncertain of the bandwidth I need.

Setting It Up
I need help on setting mySQL 4.0 on my windows 2000 small business edition server. how exactly do i do it? its downloaded, and set-up, now how do i use it?

Setting Value
I have a table (cont_id) with an auto_increment primary key, and I had deleted entries with much higher numbers than others.Those entries are no longer there, but auto_increment sets cont_id based on the high-number entry I deleted.Is there a way to re-set auto_increment so it adds +1 to the highest-number value for cont_id among the existing entries?

Setting A New Value
I'm trying to design an internet forum these days ...
In my database i have got a field called (ID) which represents the id of the topics and i have assigned it an (auto_increment) attribute...
My problem is that when i delete all the topics from the forum and after that add a new topic to the database the (ID) of that new topic continues to increment from the last deleted topic,
so how can i set the (ID) of the new topic to 1 in case all the previous topics were deleted?

Setting Up Tables
I'm having trouble figuring out the table setup and normalization I'll need to accomplish my goal.

Basically on my website I want students to register and from there they can log in and fill out what college they go to and create a list of courses they are taking and add/delete assignments for each course, and add grades they receive for each course.

I need help determining what tables I'll need and how I want to link them.

Let's say a STUDENT adds 6 COURSES and then 10 assignments in each course along with 8 grades he has received in the past week (to calculate GPA). How would I go about setting this up?

Setting Up Problemo
IM a database virgin and am wanting to get in to server side scripting.
Ive been trying to set up mysql on my machine by following this tut:
http://www.sitepoint.com/article/php...1-installation
Now ive got the mysql downloaded and installed n my machine and ive got to the point where ive opened the command prompt (im on windows xp) to installing mysql as a system device ( right towards the end of the first page in the tut).
Now ive got mysql in program files si im typing exactly this:
c:programfilesmysqlin>mysql-nt --install
but it doesnt work. Says the system cannot find the path specified but to get to the bin folder i literally go c rive then programfiles then the mysql folder then theres the bin folder right there.
Any ideas what i could be doing wrong. I dont have apache installed or anythig yet becuase the tut hasnt told me to. Is it all case sensitive, should there be a space between program and files?
any ideas?

Setting Font
I downloaded and installed mysql-essential-4.1.22-win32 somedays ago.

I found it doesn't support my mother tougue.

How can I set it support korean language?

should I install it again for setting font(character)?
or
can I modify the setting?

Setting Up A Database
I have just installed mySQL v.5 on my Windows VPS Remote Desktop.
In the past I've use shared hosting and simply followed the directions
of the web host when creating a database.

I simply need a single database created, a single user created for the database and password. And to grant permissions to that user.

Rather than read the manual, I was hoping someone could instruct me on accomplishing this, please.

Setting All Values To 0 And Some To 1
Is there a single query I can run that will set all values of a single column to 0, but set some values to 1?

somthing like:

Setting Up MySQL On Mac OS X
I'm a novice Unix user, and I can't get MySQL set up properly on my
Mac. It seems to have installed OK, but when I try to run the
mysql_install_ db script, I get errors. I can't set the root password
either that the documentation tells me to.

As background, I just want to use MySQL to work with databases and PHP
and HTML to set up web pages for database input and output. I'm running
MySQL on my own machine at home, and have no use for passwords or any
other administrative functions. I'm just looking to use the program to
set up and query databases.

Can anyone point me to a way to avoid all the UNIX admin stuff and run
the database? I can get in, but the mysql database doesn't appear when
I hit SHOW DATABASES as the tutuorial says, and I can't access or
create new databases. I think all this may have something to do with my
user account on my machine, but I'm not savvy enough to know how to
override permissions, be root, or any of that stuff. Any hints?

Setting All Instances Of A Value To Zero?
I am writing a basic CMS for a project and i need to be able to set every instance of a value to zero in a mysql database.

eg. there are 20 entries, each with the value '1' in the 'default' column. I want to change all of their 'default' values to 0 in one query.

How can i do this?

Setting Up Defaults
Is there a way to set-up defaults to the fields using some SQL statment instead of going into each field and entering default values.

Setting Up Database
im going to use mysql for my database and then i will you asp for programming. im using windows xp pro in a lan. can the computer in the lan access my database thru webpages hosted on my computer using IIS.

Setting Up A MySQL Db
how's it done? I have only ventured as far a local Access type db up until now, but I now need a db "out there" that can store info submitted from a form on one of my websites. I have recently been experimenting with phpBB as a piece of open-source (free) software that taps into MySQL on my webspace, and seems to take almost all the hard work out of setting up a complex forum.

It there some software that will do a similar job for me with a db? And can such a db download its data to a local db, like Access?

Setting Replication Up !
I am trying to set server replication up but am struggling to get binary logging enabled on the master -

DB - mysql 3.23
OS - Win2k

I have added the log-bin entry on the master - but if I do a SHOW MASTER STATUS they are all shown as NULL -

Setting The ORDER BY
ok say a field name in a table is called "type" and there are 4 possible values for the "type" field (car, boat, motor, rv). I dont want to order it by ascending or descending i want all the rows labled car under the "type" field to apear first. and the same for rv, boat, and motor. How would i acieve this??

Setting Up A Username
I am both the user and the admin. I am using winXP, and I am the root. This is all happening on one laptop since I am using Apache as a server. I have to ONLY provide mysql with my password to get into my database.

My Q is how can I assign an actual username to myself, so MySQL connects my password that is already in use with the new username which I don't know how to create?

Setting Up MySQL
I set up MySQL, obviously not right.

When I attempt to use the command:

mysql -u root -p

I am then asked to type in my password. I do that and then

ERROR 2013 (HY000): Lost connection to MySQL server during query.

I run Win XP and Norton Internet Security.

Setting Up MySQL
I tried removing MySQL But when asked for my password it would let me type it & Im log in as admin. Please Help ASAP I need a MySQL Project done. here is the terminal line:

[flash-AlPB-1GHz:/usr/local] chadelso%
[flash-AlPB-1GHz:/usr/local] chadelso% cd /usr/local/mysql
[flash-AlPB-1GHz:/usr/local/mysql] chadelso% cd /usr/local
sudo rm mysql
sudo rm -rf mysql-3.23.47-apple-darwin5.1-p
[flash-AlPB-1GHz:/usr/local] chadelso% sudo rm mysql
Password:

Setting Up On Windows XP
1) I can run MySQL in a command prompt and create databases when I am logged into it at root happily. But then my application which hasnt got root access cannot see the database. How do I set up MySQL such that myApp can access a database created by root?
At present if I log in to MySQL using MySQL -u MyAPP
I cannot access the database that I created when I logged in as MYSQL -u root

MS Visual Studio 6 question.
2) I have copied all the .h files into my include directory, and the lib files to the library directory. I have fixed the slight bug in the header files that means the system cant define SOCKET (#define __LCC__)

If I just include the headers and compile it all works well. As soonas I try to use some of the C API commands I get linker errors which implies that the library is not loaded. I have added the library and I still get errors. What am I doing wrong here (or more likely, any suggestions for other things I can try?)

Setting Max_allowed_packet
I am having a problem with adding a large String to a mySQL field.. The size of the String is ~ 4MB and the datatype of the field to which I am inserting the string is - longtext.

When I try to insert the String I get errors - i.e.
"com.mysql.jdbc.PacketTooBigException"

I have tried to set the max_allowed_packet value, in the my.ini file.
i.e. set-variable =max_allowed_packet=16M

although, when I try again to repeat the process once I have set the max_allowed_packet.. I still get the same error Message. It seems that even when I set the max_allowd_packet to 16M, the actual allowed maximum value is 1M.

Setting Up Users
I have a website and db where people can login get setup and then enter information into the db, everybody has a unique client number, can I create a user for the db when they set themselves up as a user and restrict them from changing anything except data that is connected to their client number?

Setting Variables In My.cnf
how can I issue these client commands from inside the my.cnf file?

tep_db_query('set collation_connection=euckr_korean_ci', $link);
tep_db_query('set character_set_results=euckr', $link);
tep_db_query('set character_set_connection=euckr', $link);
tep_db_query('set character_set_client=euckr', $link);

Setting Value Of Row_count()
i have a stored procedure consisting of several delete statements and i
want to be able to return the "Query OK, 0 rows affected" such that the
total number of rows deleted are summed up rather than returning the
number of affected rows of the last statement.

the number of rows deleted can be obtained through the ROW_COUNT() and i
can add it up. but how do i set the value of the "Query OK, XXX rows
affected"?

Using And Setting Up My First Database
1. how do I being in setting up my mySQL database which will be storing files consisting of TXT, SWF and images.
2. I want to be able to call these items from the database using PHP links and MySQL/PHP integration. Any tutorials on the web available for that that anyone knows of?
3. Easability. Where can I go to learn how to optimize all my code?

Setting Up New Item
I use myphpadmin and I am a beginner with it. I have this text based game and for items it's weapon, armor and shield.

I went to insert and did the fields and added a new item called "Herb" which heals your character 10 health. So now I go to the game to the admin control panel and its there but it can only be a weapon, armor or shield. I need to add a new class for "items" which is a healing item.

Setting Up A Relation
Is there any reason why two tables created with a relation in MySQL
wouldn't adhere to what you would think is a property of the relation?

Case in point: I have a 1:n 'relation' where I can insert values into
the dependent table while making up an entry for the foreign key from
the independent table (whether it exists or not). I shouldn't be able
to do that, but MySQL doesn't complain.

Setting Value For All Records
How would i go about populating a new column based on an existing column
pluse a bit of text.

i.e i have a column fldID which contains numerics 1,2,3,4 etc and i want to
poulate a column fldIMAGE with values 1.jpg, 2.jpg etc.

Setting Up A SQL Table
I want to use this:

$sql = "SELECT * FROM blogroll ORDER BY rand(" . time() . " * " . time() . ") LIMIT 1";

To pull random code into my WordPress theme (I will need to use lots of these random entries, so this method looks best, ATM).

Do I use this by creating a table in my database and replacing "blogroll" in the above line with the name of the table(say: randomphp)?

I will try this as soon as I figure out how to fill in the fields in the new table.

If I am correct about what I need to do please help me out with the fields on the table creation screen in phpMYadmin:

Field?
The code I want to put in place of the SQL string in my theme, right (a php include to be specific)?

Type?

Length/Values*?

Attributes?

Null?

Default**?

Extra?

primary, index, unique, or ---?

full text?

Setting A Maximum
I'm trying to get summaries of articles from my database, and I've tried a couple things though none of them seemed to be correct.

In my SELECT statement:

SELECT * FROM articles WHERE id=$_GET[id]

I want to specify how many characters(maximum) it should return. The field I want to limit is longtext and there are three other fields (2 varchars, and a date) but none go over 30.

I assume that this is possible since creating a separate field that contains a summary would be extra overhead.

Setting Up MySQL
This is how the server is started:
mysqlinmysqld --defaults-file=mysqlinmy.cnf --standalone --console

There's no "--old-passwords" but it's still not working.
I have Xampp, btw.
In my.cnf I took out the "old_passwords" declaration. I restarted the server a few times and it's still not working.

Setting Max_allowed_packet
I can't seem to set max_allowed_packet on server restart. Typically, to set it higher I've been restarting mySQL through the command prompt using the --max_allowed_packet=64M, but I want this to happen by default on server restart.
I tried editing my my.ini file with no success.
I've tried adding the lines:
max_allowed_packet=64M
--max_allowed_packet=64M
max_allowed_packet=64M
max_allowed_packet=67108864
and
--max_allowed_packet=67108864

Still, on server restart it always is the default 1048576.