Why Is The Password I've Created Not Being Recognized?
Login not recognizing that I've set a password for the user?
I have set a password for a new user I have created, however I can't login using the password (get a "Access denied" error), however I can login with no password? Can someone help me out please? I've attached below console out. You'll see I have included "ps" output as I'm wonder whether I could have more than one instance of mysql running?
login as: root
Authenticating with public key "imported-openssh-key"
Passphrase for key "imported-openssh-key": ......
View Complete Forum Thread with Replies
Related Forum Messages:
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.
View Replies !
Foreign Key Not Recognized
I add foreign key to my tables, but mysql seem to don't consider them. For exemple the table BIERE (beer in english) : CREATE TABLE BIERE ( NOM VARCHAR(20) NOT NULL, TYPEB VARCHAR(20) NOT NULL, ORIGINE VARCHAR(20), COTE VARCHAR(10) NOT NULL, PRIMARY KEY(NOM), FOREIGN KEY (TYPEB) REFERENCES TYPEBIERE (NOM) on delete cascade, FOREIGN KEY (ORIGINE) REFERENCES ORIGINE (NOM) on delete cascade, FOREIGN KEY (COTE) REFERENCES COTE (NOM) on delete cascade ); So the foreign key typeb come from the table TYPEBIERE (white...brown..etc) But if I do an insert of a beer and I type "Love" for a type of beer (Love isn't in TYPEBIERE) MySql don't show any error and add this beer to the table?
View Replies !
'show Warnings' Is Not Recognized
I downloaded mySQL and have been running most things with sucess. In case it is pertinent, I used the mysqld-max-nt --install command to install. I have version 4.1 However, when I run a query that produces warnings, I am still not able to view them. I get your typical Error 1064 for bad syntax. However, I've confirmed from mysql.com that the syntax is correct.
View Replies !
User Accounts Not Recognized
I am the administrator and asks for my password (that's ok because I am the administrator). The downside is, no where did it ask me for a user name. I've tried using "root", because, well it is the root file and I am the administrator. Just to test this out, I set up another account and password. MySQL acknowledged it and going through and being set up correctly, but I can't log on as that person or access it through PHP. I was reading in the reference manual that GRANT files should be automatically set up. When I go into my MySQL file,I don't see anything there regarding grants or privileges or users. When I start writing PHP to create and access databases, how will it recognize me if I never set up a user name? Perhaps this should be in the PHP forum?
View Replies !
MySQL Isn't Recognized By My Server
I configured PHP to work with Apache, but it doesn't seem to detect MySQL. When I access the phpinfo.php page MySQL isn't in the list, and when I open phpMyAdmin, it tells me it "cannot load mysql extension." On the official PHP (http://www.php.net/mysql) it gives the following configuration instructions for MySQL and PHP 5+: "MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the Windows systems PATH. See the FAQ titled "How do I add my PHP directory to the PATH on Windows" for information on how to do this. Although copying libmysql.dll to the Windows system directory also works (because the system directory is by default in the system's PATH), it's not recommended. As with enabling any PHP extension (such as php_mysql.dll), the PHP directive extension_dir should be set to the directory where the PHP extensions are located. See also the Manual Windows Installation Instructions. An example extension_dir value for PHP 5 is c:phpext" So I follow their advice and set extension_dir = C:/www/php/ext/ (where php_mysql.dll is located) and copy "libmysql.dll" into the Windows folder, but the server still doesn't seem to recognize MySQL (it's not in phpinfo.php and phpMyAdmin gives me the error).
View Replies !
Mysqldump Is Not Recognized As An Internal Or External Command
OK I am running mysql 4.1 on Windows XP, I have a database called silentcopy. I want to export it as a file so that I can upload it to my server and unpack it there. I am under the impression that the best way to do this is to use mysqldump. I am having no luck, if I try it in the MySQL Command Line Client I get:- ERROR 1064 <42000>: You have an error in your SQL syntax; If I try it on my command prompt, then I get:- 'mysqldump' is not recognized as an internal or external command, operable program or batch file.
View Replies !
Log-bin Not Created
I am using mysql version 4.0.12 on a solaris sparc box. My server has stopped creating the log-bin files although it is defined in my.cnf. The directory permissions of the data directory are fine. What is wrong with the setup?
View Replies !
Format Be Created?
I have 2 tables: Table1 contains (among other things): ID Data1 Data2 Data3 1 aaa bbb ccc 2 ddd eee fff 3 ggg hhh iii Table2 contains (among other things: ID Key Value 1 20 zzz 1 30 yyy 1 40 xxx 2 20 www 2 30 vvv 2 40 uuu 3 20 ttt 3 30 sss 3 40 rrr I need a query that returns: ID Data1 Data2 Data3 Value Value Value (Key=20) (Key=30) (Key=40) 1 aaa bbb ccc zzz yyy xxx 2 ddd eee fff www vvv uuu 3 ggg hhh iii ttt sss rrr Any ideas?
View Replies !
HOW DO CREATED USERS LOG ON
I did install WIndows community 5.1.30 successfully on my PC, I used mysql CLI to create users (identified by passwords) and assigned database level priviledges, something happen: 1: When I restarted mysql CLI, with the passwords of the created users, MySQL does not regconize them. I am unable to log unto the server or even the CLI of MySQL.ie when signing on as that user. Only root account can log on. Meanwhile, I can log on to MySQl Query Browser with the other users I created. strange!!! This is even when I can see the users created and existing with the command: select Host, User from MySQL.user; 2. How can I log on as the created users? or how can the users I created log on.
View Replies !
MySQL Cluster Created
If a cluster is created using 4 computers, (2 running DB nodes, 1 running MGM node, and 1 running API with apache running PHP app) the application querying the cluster would query the API node running on localhost, correct?
View Replies !
Dynamically Created Indexes
I've wandered through previous threads but can't seem to find any info. How realistic and sensible is it to dynamically generate indexes whenever a SQL statement is called? Then de-index that table to allow updates/deletes/inserts?? SO basically, indexes are only generated when information is requested and thus they are disabled for routine maintenance?
View Replies !
Overview Of The Created Databases
Are there anyways I can view all the databases I have created so far and maintained lately? I believe there is something which looks like select * from metafile... or soemthing :) I have tried the command "status"
View Replies !
HOW DO CREATED USERS LOG ON MySQL CLI?
I'm new to MySQL. I've managed to create users who exist on the server but My Created users still can't log on the my SQL CLI. I'm burning within. can you help please? I installed MySQL successfully on a windows OS for personal use. I created the users with the create user Syntax: mysql> CREATE USER BON IDENTIFIED BY PASSWORD pass; then mysql>CREATE USER 'Bruv'@'localhost' IDENTIFIED BY PASSWORD garden; then GRANT ALL ON DATABASE_NAME.* TO BON; GRANT ALL ON DATABASE_NAME.* TO 'Bruv'@'localhost'; AFTERWARDS, users BON and Bruv are able to log unto MySQL query browser successfull BUT UNFORTUNATELY they cannot log unto the MySQL Command Line Interface. when I try loging them on with the passwords 'pass' or 'garden' (their identified passwords), I am denied and CLI exits. (MySQL CLI always requests password upon startup and only root account can log on) During the installation with the Installation wizard, I did not check the 'allow users to connect remotely' box. Could this be the reason?? Please help Brilliant guys!!
View Replies !
Pages Are Created On The Fly By Rows...
I have a MySQL database and I want to echo one field (Title) into a page so it can act as a link to that row. When someone clicks the title, I want that row's information to come up. For example Example Title Example Title 2 Example Title 3 User clicks Example Title 2, Example Title 2 | Example Author 2 Example Description. To be displayed. I know this requires "index.php?=". I just don't know what its called and I can't seem to find any tutorials about it. How is it done?:(
View Replies !
Table Already Created Error
I'm using mysql v4.x and am using a php script to try and create a mysql table and insert values from an xml source. The script seems fine, but I keep getting an error saying ''table already created'' also the records that it has created in the tables it partially made are duplicated. Any ideas?
View Replies !
Re-created Table Failing
Re-created a table in my database. All field names and values are identical to the original table. Table name is correct too. Now the web-pages will not store data to the table.
View Replies !
Timestamp - Only When Created Mysql
How can i add a timestamp that is only updated when the record is inserted, not when the record is updated. A kind of "date created" stamp. Can this be done by setting the field up in phpmyadmin - ie not in the script im using (php)
View Replies !
TIMESTAMP : Created & Modified Fields ?
I have a number of tables that I want 'timestamped' with both a modified and created 'timestamp' field. Ideally both fields should 'work if ignored' in insert and updates, thus the following is fine for a modified timestamp field tsm: tsm timestamp default current_timestamp on upate current_timestamp But is there a way to create a field that in effect is 'write once' and contains the creation timestamp ? In a sense I want some thing like (psudo sql create line): tsc timestamp default current_timestamp 'on_update_do_nothing' I think a second timestamp with 'default current_time' would help but mysql does not allow this - (I have no idea why !?) There are quite a number of tables and I want to avoid 'table specific' sql code like the following (psudo sql): insert record ... get last update auto increment key select modifed timestamp value from key record update key record create timestamp field with timestamp Any ideas (for a 'write once' creation timestamp)?
View Replies !
Stored Procedure Cannot Be Created From A File?
Im having my 'create procedures' syntax in a file and im reading it line-by-line and storing it in a string and finally executing that string..... however this is not accepting the 'Drop function if exists' syntax within the file.... it throws an sql exception error. example: (which throws error) ....
View Replies !
Edit All Records Not Created Today And With A Certain Value.
I have a script that runs every monday @ midday and in this script it connects to my database. I want to basically do the following. Look at all records that have a active value of "1" in teh active column. Then if those records are older than today in the datecreated column xxxx-xx-xxxx:xx:xx change active to "0" So something along the lines of ( Sytax will be crap but hopefully you understand ) UPDATE data SET active = 0 WHERE active = 1 and datecreated = NOT TODAY (ie:yesterday or before. )
View Replies !
Select Rows Only Created LAST MONTH
i want to run this below command, but only look at records from the previous month and where ACTIVE = 0 MYsql> SELECT user,ROUND(AVG(overalldone), 1) AS average FROM data GROUP BY user ORDER BY average DESC;
View Replies !
Can't Open Pdf Link Created In PHP/MySQL
I created a MySQL database with all the pdf papers on my HD. The path to a pdf file is stored e.g. D:DocsPapersBerg2003a.pdf In php I do the query and output the link: echo "<a href='file://" $row->pdf ."'>pdf</a>"; But when the page is generated and I click on it nothing happens. If I do right click, copy link and paste it in the browser field, the pdf file opens though! Looking at the html code, it reads in Firefox: <a href="file://D:%5CDocs%5CPapers%5Cwind03%5Cpdfs%5Berg2003a.pdf">pdf</a> and in IE6 <a href='file://D:DocsPaperswind03pdfsBerg2003a.pdf'>pdf</a> I have also tried .str_replace('','/',$row->pdf) but with the same result.
View Replies !
Script Runs, Tabels Not Created
I created a database, which at the moment is empty. I have a script to change that and add in a load of tables and other values. I can run the script from the graphical MySQL Query Browser, and my database gets a little arrow like it has data in it, and it produces no errors. When I try and run a Tomcat apache server it say ERROR: -table "Blah" does not exist. And when I go back to the query browser, the arrow has disappeared and there is no data in my DB.When I try and say source myscript.sql from the command line in order to give my DB the necessary tables, it says "ERROR.. etc ..no database selected. Question is, how do I select a database?
View Replies !
Mysqlorary Table Created But Doesn't Exist?
I am trying to create a mysqlorary table with: CREATE mysqlORARY TABLE t2 SELECT col1 as col2 FROM t1; This appears to work, but when I then run a 'SELECT * FROM t2' query I get told that t2 doesn't exist. What I am I doing wrong?
View Replies !
Deleting Files Created By INTO OUTFILE
I created output files using the INTO OUTFILE. I redirected the files to be stored in my local drive. But when I try to delete these files if returns an error : Cannot delete test: Access is denied. Make sure the disk is not full or write-protected and that the file is not currently in use. I do have the permission to delete or modify the files. I can delete any other document within the same drive. I even reboot the computer and tried deleting but it just does not want to be deleted. FYI, these files are in the .dat and .txt format.
View Replies !
Custom Columns Created For Clients
I have an odd problem that I need a solution for. I have a table that has perhaps 10 default columns. My clients need to be able to add their own columns to this table independently of eachother. I would also like the solution to work with link. I prefer to not create a unique database for each client.
View Replies !
Users Created From January Cannot Logon
Login access is granted based matching an username and password and if found, the access level is used to display the right menu options. I know this might be vague, but if one has experienced this before then one will know what i am talking about. I have checked the database and the data is correct.
View Replies !
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.
View Replies !
Changing Attribute/column Names Once Created.
I've just created my tables in mysql, only I've just realised that one of my table names is wrong and wish to update it. How do I do this? It's easy to update the data in the tables, but I don't know how to change the column names themselves. Will I have to drop the table and start again? Thinking of it, it does solve my problem, but I would still like to know how to update it.
View Replies !
Deleting A File Created By SELECT INTO OUTFILE
I am running a shell script that has the msyql commands: select "Data Load Complete" into outfile '/mysql/testfile.txt'; The textfile gets produced fine. My problem is I am not able to delete this file in the shell script because the owner is the mysql server. But I also don't know to delete the file directly via mysql.
View Replies !
Database-Scheme Created With DBDesigner Looks Wrong...?
I'm working on a little project for my school. It's a little learning program that allows teachers to enter questions for each grade and difficulty-level. Their students can then choose their grade and their difficulty-level, get asked ten questions and then their results get saved and the teachers can print them out or just look at them. For the database-scheme I used a program called FabForce DBDesigner. I've never used anything like this before, but it is so much easier to work in such a program than writing your tables out in SQL. But the program produces VERY, erm, suspicious results. Take a look at it yourself: DB-Scheme Especially the table "UsageStatistic" is a good example of what I mean. I would never, ever had designed a databse with the exact same relations the same way. I mean, the program creates a hundred different keys and indexes. Now my obvious question is: Is this actually very good db design? I certainly wouldn't have done it, but maybe it is exactly what would be perfect. Btw, the db-design isn't really finished yet, of course. I will add some more things and that will again create some relations to the other tables, which means even more indexes and keys...
View Replies !
Created And Modified TIMESTAMP Columns -- Sans TRIGGER?
is it possible to get MySQL to give me a created TIMESTAMP column as well as a modified TIMESTAMP column? Or, perhaps use a DATETIME for one of them? It seems there's some implications to using the 'default' attribute and/or the NOW() function in this situation. I'm most concerned with not having to use a trigger. Ideally, I'd like to have this entire function remain in MySQL, and not have to fiddle around with the App calculating and storing this info. Is there a 'best practice' or most elegant solution for this kind of thing? Oh, and I'm 5.0.xx , but could be persuaded to upgrade to 5.1 if need be
View Replies !
Date Created Field Shows 10 Digit Number
The database I am using seems to store its dates in a 10 digit format. For example, a table that has a date created field stores its data as a 10 digit number (1218437735). I need to be able to show these as a (proper) dates and to be able to do calculations (datediff and add/subtract) on them.
View Replies !
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.
View Replies !
Password :: Change Password
I have trixbox 1.2.3 running and in freePBX it told me I need to change the password in mysql. I went into mysqladmin and privileges. I updated the passwords for a2billinguser and root. Now I am denied from access to mysql and all services that use mysql don't work. How do I restore the default that trixbox used. I have a very large major system here and cannot just blow it away.
View Replies !
Copy User Privileges To A Newly Created User.
I have just created a user with specific permissions to certain tables in different databases. Now I have to create serveral more users with the same permission. Is there a command in MySQL that allows me to create the new user by copying the privileges from a template user?
View Replies !
Can't Access Created DB's Via PHP, Though Can Access Them Via PhpMyAdmin
I can create databases via mysql-shell and edit them. These then do show in phpMyAdmin and are editable. BUT, if I try to access these db's via a normal php-script (i.e. $ergebnis=mysql__list_dbs($server)), it only shows me one database, the test-db. (To show them, I use a for-loop which counts the elements in $ergebnis from 0 to the number smaller than mysql_num_rows($server) and then prints the string.)
View Replies !
|
TRACKER
