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.
View Complete Forum Thread with Replies
Related Forum Messages:
Fedora Core 2 Server Installation
I have a Fedora Core 2 server, and need to install MySQL for one of the websites on it. I downloaded the MySQL RPMs. Do I just rpm -Uvh them? Or is there anything else that needs to be done? And once I have MySQL installed, what do I need to do to let the user do what they need to do? Remember, I know nothing, so please no "well, we need to know what they're going to do..." I don't know, and don't care. If there's a way to limit it so that their database can't take over my whole machine, great, but this is a long-standing, trusted client, so if I need to give them the keys to the MySQL castle, fine.
View Replies !
Mysqlclient On Fedora Core 4
I am trying to upgrade on fedora core 4 mysql to mysql 4.1.20 I am using source rpm to build it on ppc architecture. When i run the rpm -uvh command and complaints about libmysqlclient.so.14 missing This file is found in mysql client but i can not find mysqlclient source rpm that contains this file.
View Replies !
Fedora Core MySql
I have installed server,client and devel of mysql-4.1.11-2 on Linux Fedora. I am not able to start the mysql. The erroe I am getting is ERROR 2002 (HY000) : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' Now this mysql.sock is present in /var/lib/mysql/ directory it is present in /tmp Even I tried /etc/rc.d/initd/mysqld -restart then sql stop and sql start both FAILED
View Replies !
MySQL-4.1.7 On Fedora Core 2
I installed MySQL from source and it ran fine. After I reboot it shows the mysqld running but it doesn't work. I've tried killing mysqld and starting it back up. I've even tried reinstalling it and it runs fine until I reboot.
View Replies !
MySQL-5.0.22 On Fedora Core
I want to install MySQL-5.0.22 on FC4. Also PHP and Apache. Can any body tell me what are the minimum version of PHP and Apache, that I need with MySQL-5.0.22 on Fedorea Core 4
View Replies !
MySql And Fedora Core 5
I'm trying to install mysql 5.0.22 on fedora core 5. The server has a Xeon processor. I thought using the generic rpm's would be the easiest way to install but neither the dynammically or statically rpm's work. I installed Fedora without graphical interface as a development machine with most development packages enabled. Also I did not install the MySql included in fedora because i want to install the latest version. Installing the dynamic version of the rpm's results in a dependancy error stating that perl (BDI) is needed Installing the static version of the rpm's results in a weird (that is, weird for me) error: "Asked for 196608 thread stack, but got 126976" after that the installation fails. What's the best way to install MySql on fedora 5?
View Replies !
Login Fedora Core 9
I had installed mysql 5.0 along with FC9 linux distribution.what is the default root password for mysql root login. I am able to login with user SU and password blank i.e. no password. But for root I am unable to login with root username. I tried with no password, root . But in anyway I am unable to connect mysql using root username. How can I reset password.
View Replies !
Upgrading 3.23 To 5.0 On Fedora Core 3
I can't locate a message that describes this. I have Fedora Core 3 running with MySQL 3.23. I need to get to 5.0 and read somewhere on this site that I should first upgrade to 4.x then to 5.0. There was a page that explained this. Is there a link to some info that explains the correct way to do this.
View Replies !
Strange Auto-increment Behavior
If I insert data to a table which has an auto-incrementing id-column, the id does not increase as I expect it woud. In a table with 4 values (numbered 0 to 3), for example, a new row inserted began it's ID at 43, then continued to 44, 45, etc. Another related issue is that if I restructure a table that has data present in it, the row with an id of 0 (on an auto-increment column) jumps around to a seemingly random high number, again, like 43.
View Replies !
Uninstalling Mysql From Fedora Core 3
I have fedora core 3 with mysql 3.23 .Now i want to uninstall mysql 3.23 because I want to install mysql 4.1. As my very new in this field. would anybody tell me how to unstall mysql 3.23 from fedora core 3. I tried through system tool "remove software package" but could not get the result I want
View Replies !
Queries Of MySql On Fedora Core 4
I have the following queries about MySql on Fedora 1. The Package is already installed on fedora.I want to run the MySql server and Connect a client to it 2. How to use Mysql and Java (jdbc).please tell me the procedure. 3. how to install the drivers,connectors.
View Replies !
Fedora Core 5- MySQL Downgrade
I've a new dedicated server that runs Fedora. I'm much more familar with debian so i just wanted to get a bit of advice on here. It has mysql5 installed by default but the online shopping cart sofware we use has a problem with mysql5 so i want to down grade to mysql4. So is there a safe way to do this using RMPs?
View Replies !
Strange Behavior Of Properties Section Of Database
We recently moved our company to a new building, and servers along with it. Although our mysql database is still on the same server, ever since the move, I have a lot of difficulty (impossibility) getting the properties portion of the table to click open so I can see the fields. I need to get in there to add new fields and so forth. In some cases, I cannot even browse the tables to view the contents. Can someone explain what the problem could be, and how to fix?
View Replies !
Latest MySQL Version With Fedora Core 1
I currently have a server running Fedora Core 1. I ran the "yum update" command a couple of minutes ago to upgrade all files from the repository, and it didn't upgrade my MySQL installation (3.23). I checked the repository and that was the latest version it had. My question is: can I install the latest MySQL version (with RPM, uninstalling the 3.23 package first) on my current version of Fedora, or will I have installation or performance/stability issues?
View Replies !
Strange Alias And Join Problem On Server But Not Dev Box
I'm running MySQL 5.0.45, php5 and apache 1.3 on windows xp for development. All my tables are MyIsam. The following query works fine : MySQL SELECT i.image_id, image_filename, region_name, monument_name FROM image AS i LEFT JOIN image2region USING(image_id) LEFT JOIN region USING(region_id) LEFT JOIN image2monument AS i2m ON (i.image_id=i2m.image_id) LEFT JOIN monument USING(monument_id) WHERE region_name='egypt' LIMIT 0, 8 On the server (MySql v5.0.15) where I plan to host the site I get the following error: #1054 - Unknown column 'image_filename' in 'field list' If I give all the tables aliases and prepend all the column names after the SELECT with the aliases it works but I don't want to have to do this with all the queries I've written. I don't understand why it doesn't work on my dev box but not the hosts server. I have also noticed that this problem only seems to arise on queries with more than two joins. Has anyone else experienced a problem like this? Or should I be prepending all columns with aliases as a matter of good practise anyway? Cheers x
View Replies !
Setting Password
I successfully added MySQL, setup db's and did initial app development. I did all of this under the root user and blank password. When I ported the new development to the web site I tried to setup a user and password for the application and set the root password and ran into a brick wall. I am now locked out MySQL in terminal mode, phpAdmin will not save a config, MySQL GUI Admin will not save passwords and under options it says it cannot locate the /etc/my.cnf file. I have looked at a number of tutorials to set up the my.cnf file and they seem to conflict with one another and have been reticent to take action to make sure I was going in the correct direction. I am using QS10.4, phpAdmin 2.11, MySql 5.05, GUI Tools for 5.0. Can anyone point me the right direction to line up all of the security related files to get control back, successfully run the app on the local environment and and continue development.
View Replies !
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.
View Replies !
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?
View Replies !
Setting Password Problem
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?
View Replies !
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.
View Replies !
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
View Replies !
Setting Root Password
I am using MySQL 4.1 on Win XP.I forgot my root password and I am trying to reset it. I am using the SQLyog GUI to manipulate my DB.I have a guest password stored in SQLyog and can access all of my databases.But I can't use SQLyog to change the password b/c it uses the new password alogorithm which is hashed to 32 characters opposed to 16 in the old alogorithm.I was wondering a way to reset my root password. I only have minimal privileges on this account such as SELECT. Just in case anyone missed it, I can't log into my MySQL command line client since I don't know my root password.I would normally use OLD_PASSWORD('password') from there.
View Replies !
Authentication :: Setting Root Password
I am trying to set the root password, but all I get is: $ ./mysqladmin -u root password <newpassword> ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I have no problems connecting like this: ./mysql -u mysql In the latter case, I cannot do anything. For example mysql> CREATE DATABASE one; ERROR 1044 (42000): Access denied for user ''0'localhost' to database 'MoonlightDB'
View Replies !
Setting Password For MySQL From WAMP?
A few months back I installed WAMP (one big installation of Apache, MySQL and PHP for Windows). The last week I'm busy with Portal development. As a result I'm trying to install Jetspeed-2. The installer of Jetspeed asked what Database I would like to use. As I installed WAMP I thought it wiser to stick to MySQL. When I started phpMyAdmin I saw the following message: "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account." As it is some time since I installed WAMP I cannot remember what I need to do. I searched the install directory and found that the word password is contained in several .ini files (my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini, my-medium.inim and my-small.ini, but not in my.ini). The format of the line is: #password= your_password I take it I need to remove the # at the start of the line, replace 'your_password' with a password of my choosing? But in what ini file? How does WAMP know what ini file to choose? In the same directory as the ini files I see a wampserver.conf file. In it there is an entry: $mysqlConf['mysqlConfFile'] = 'my.ini'; Does this entry make WAMP to choose for my.ini? I plan to use the WAMP/MySQL installation purely for development purposes.
View Replies !
Setting Password & Salt Then Cannot Login
I go into "phpmyadmin" mysql admin gui and set a passwd and salt for an account ..... i enter username as <usernametext> ... that is plaintext i enter passwd as sha1(<passwdtext>) so it displays in table encrypted i enter salt as <salttext> .... that is plaintext now below is authen logic for login .....
View Replies !
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.
View Replies !
Setting Mysql Root Password On Mac
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:
View Replies !
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?
View Replies !
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.
View Replies !
ERROR When Setting Password Via Console (MySQL V 5.1.30
I am trying to set a password via the console with the following: mysql> update user set pasword - password<'password'> where user = 'root'; and receive the error message: ERROR 1064 <42000>: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where user = 'root'' at line 1
View Replies !
Setting Up The Server
I keep getting an error number 1045 access denied whenever I try to run MYSQL Administrator. I just set this up. What did I forget to do? I installed MySQL Server 5.0, the administrator, the query browser and the system tray monitor. What am I forgetting to do here?
View Replies !
Install On Fedora 5 Or Fedora 6
I am playing with Fedora 5 and Fedora 6. Since I do not see a MySQL version specifically for Fedora in the Download section on the mysql.com web site do I use the non-RPM version? I have yet to install MySQL on the machine (probably already there...but probably an older version). Using that version makes sense to me but I wanted to ask. And, since I will be installing these on Intel based machines I probably want to use the "Linux, non-RMP,Intel C/C++ compiled, glibc 2.3" version? I know that this is really a rookie question. I am a Windows person slowly moving over to the other side.
View Replies !
Setting Max_allowed_packet On Server Restart
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.
View Replies !
Setting Up A MySQL Server With SBC Webhosting
So I got into my Database Tools section and all I have is this: * Documentation * File Importer * Monitor Table maintenance and testing * Schema Viewer View table definitions * Database Dumper Export table contents and definitions Special Notes: * Access to your MySQL Database will require that you supply your userid and password. * Download myodbc, a Windows 95/NT ODBC Client, from the MySQL Homepage. * For ODBC access use port 3306. There is NOTHING that tells me WHERE to access my MySQL Database, and myODBC does nothing for me because I don't know where my Database is (I've tried using it to in various ways and can't get anywhere). I have no idea what to do with that port number. Could someone help me out?
View Replies !
RESET Password Of Mysql On Mac OS Server
Can somebody help me reset the password on mysql ? I need the commands to force the change cause I can't login to mysql. I am using mac os server 10.3.9 and I have messed up the mysql password I have full access priviliges on the mac server.
View Replies !
Lost Username And Password To MySQL Server....
I have been using the MySQL control center and had my usernames and passwords for the MySQL server stored in the control center. I recently lost everything on my PC including the usernames and passwords. Does anyone know if there is a way to reset or remove the passwords from MySQL so that I can make new ones? I do have the root password for the server that MySQL is running on.
View Replies !
Odd JOIN Behavior In 4.1.7
The JOIN problem I'm having is in a LEFT JOIN. Specifically, I'm joining ON user.user_ID = permssions.user_ID. The WHERE clause specifies only rows with NULL values for a value in another permissions column should be returned. In 4.0.x, it worked just as expected. In 4.1.7, however, if there's anything at all in the permissions table, the query returns no results. This is bad, because the point of the JOIN is to filter out permissions that have been denied to a user, so by returning nothing, it effectively denies my users ALL permissions, so no one can log in or do much of anything.
View Replies !
Security/behavior
I'm evaluating a project of mine to see if something would go wrong if a user started using the wrong character set, and I can't seem to determine from the MySQL manual what the behavior would be if a query attempted to insert a string with the wrong character set (including single byte and multibyte character sets). Would it treat each byte as if it were already part of the default character set? Or would it throw an error? How would it even know? I'm doing this with PHP so I know to use the "real escape" functions to escape the input, but I think it would still be good to know what is actually going on, and I don't have much experience with charsets/collations...
View Replies !
Different Behavior Of Clients
There is problem. diffent MySQL clients have different behavior. I used simple sample from mysql manual (for example) : SET @t1=0, @t2=0, @t3=0; SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3; If I paste it in command line, it works good. But, then I tring to execute it Query Browser, I got error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3' at line 1 If I use .Net client library mysql-connector-net-1.0.7, I got same error message.
View Replies !
Odd Mysql/php Behavior With LIKE Clause
SELECT rownum from(SELECT @rownum:=@rownum+1 rownum, t.*FROM (SELECT @rownum:=0) r, (SELECT Application FROM application_list_1.application_data_table a ORDER BY Application asc ) t) s WHERE Application like '$app%' order by Application asc limit 1 where $app is my search query passed in from an html form. This query is run in a PHP script. I run it with the following code: $row = mysql_fetch_assoc($sql); return $row['rownum']; This works 100% fine EXCEPT when I pass 'a' or 'A' to the query from the html form. Every other letter or string works just fine except the 'a' or 'A'. Also, I can run this query within MySQL query browser with 'a' or 'A' and get valid results.
View Replies !
|
TRACKER
