PhpMyAdmin :: Password In Config.inc.php Not Working
I have had it running on here before, and used it lots, but have been in a hiatus from computing for some time, and am back at it agiain, but when I tried to access my test site or databases with phpMyAdmin, it simply wouldn't work for me, so I reinstalled mysql and phpMyAdmin. I can access mysql as root via command line, but when I enter the user root and password in the config.inc.php file, then try to log on to phpMyAdmin, it does not let me in, the password box just keeps re-appearing.
I have followed the instructions very specifically a number of times now and still nothing.
Anyidea on what dumb mistake I am making??
in the mean time, back to the command line... sigh
View Complete Forum Thread with Replies
Related Forum Messages:
Configure A 'config.inc.php' File (was "phpMyAdmin")
This is my first go at creating a PHP/MYSQL website so please could someone help me? Basically i'm using phpMyAdmin to manage my MYSQL database on my webserver. However you have to configure a 'config.inc.php' file before you can use the system. Can anyone talk me through what settings I need to include in this config file to make it secure? Mainly i'm worried about the differences between 'cookie', 'conifg' and 'http' modes. What do they mean (i've tried reading the FAQ's but they don't help much for newbee's!)? Which one should I use? I hope someone can just give me some clear advice on what I need to do to get my database online and relatively secure.
View Replies !
PhpMyAdmin Isn't Working
OK, phpMyAdmin can't create a table, it produced this code: CREATE TABLE `photos` ( `name` VARCHAR( 255 ) NOT NULL , `desc` TEXT( 500 ) NOT NULL , `url` VARCHAR( 255 ) NOT NULL , `cat` INT( 4 ) NOT NULL , `id` INT( 4 ) NOT NULL , INDEX ( `name` , `desc` , `url` , `cat` , `id` ) ) and this error: MySQL said: #1064 - 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 '(500) NOT NULL, `url` VARCHAR(255) NOT NULL, `cat` INT(4) NOT N .
View Replies !
PhpMyAdmin Not Working With MySQL 4.1.7?
It says authentication error.... client not support the current authentication requested by the server, please try upgrading the client. I used the latest version of phpMyAdmin but it doesn't work. MySQL works fine on command prompt and root (password set) account works fine.
View Replies !
PhpMyAdmin Editing Multiple Records Not Working
I'm trying to modify more than one record at a time. I'm checkmarking all the records I want to edit, but when I click on the edit button next to where it asks what to do "With Selected:" it only gives me one record to edit at a time. Any way to fix this pain in the @$$?
View Replies !
Have To Set Password In Phpmyadmin
I am using php4 and mysql and running them in IIS. I installed all in C:. Then I put phpmyadmin folder into the wwwroot folder. When I login http://www.mysite/phpmyadmin then it display the login page of username & password. If I keep blank those 2 fields it just direct enter to the "welcome page" of the phpmyadmin & doesn't show any option to change password or other option of the mysql. So the problem is any one can login directly to the database of the mysite. Please tell me what should I do??? Is it for mysql setup (its userid & password), or php setup or itegration os there version or something else?
View Replies !
PhpMyAdmin :: Root Password
I have given root a password in MySQL, but now phpMyAdmin says "access denied". I've put the following line in config.sample.inc.php: Code: $cfg['Servers'][$i]['password'] = 'password_goes_here'; but it doesn't seem to make any difference. How do I get phpMyAdmin to recognise my root password?
View Replies !
PhpMyAdmin :: Default Password?
I have just installed PHPMyAdmin on my SUSE 10.2 PC. When I address it in my browser I get the login but I do not know what the default pwd is. I have tried Root+<rootLogin> and blanks buit each time I get a blank screen.
View Replies !
Username And Password For Phpmyadmin
I have to put a password and username for that php page where is index for phpmyadmin, my site is on some german windows server, which is user-nofriendly, no support, so these guys can not help me. I tryed with http auth or cookies, its not working, only config (which is without password. If i use http authentification, i allways have a small window for user and pass, but if i write a proper user/pass it pop up again, like its not a good pass or user.
View Replies !
Implement Password On Phpmyadmin
we all work in a network environment. we all can access phpmyadmin of any other. is it possible to implement password on it. i want if anybody try to access my phpmyadmin e.g.(aamir/phpmyadmin, aamir is my system name), a dialogue box of password will come. if he enters the right password, he can access that.
View Replies !
Lost Phpmyadmin Password, Can't Do Backups!
I'm trying to run a backup on a bitrock install sugarcrm on linux. apache is running on port 8888, i try to get into phpmyadmin but it asks for user and password. I don't know what the user/password is. I saw user file so i know user = administrator. but I don't know password. I have access to the httpd.conf file. I see the last part of the file concerns authentication for phpmyadmin. Is there a way to turn off authentication? I just need to get a backup. I also try to use the command line but i get error 2202. it can't read the /tmp/mysql.sock file. i know mysql works because sugarcrm works fine from a browser.
View Replies !
How To Create User And Password In Phpmyadmin
I built a couple of databases on my new localhost for Joomla, and did not specify uesrname and password, and guess what? I know about the security issue, but worse than that, installation cannot continue until I can figure out how to create username and password, either in a sql window, or mysql console,
View Replies !
Password/Username Locked Me Out Of PhpMyAdmin
I'm using MySQL 5.X on a Mac. I was trying to create a password and username for a new database. I created the database, then clicked on Privileges. Next, I created a password and username. Not only can I not access the database, I can't even access phpMyAdmin now; I get this error message:
View Replies !
What Is A Config File ?
The following message shows me an error at my Config Wizzard "The template configuration file cannot be found message "C:Archivos de ProgramaMySQL Server 5.0MySQLinmy-template.cnf" Any thoughts?
View Replies !
Installation And Config Of MYSQL
Installed Mysql in Redhat 9.0 workstation. I have installed MYSQL,Appache,PHP. PHP,Appache installation is fine and intergration is also working fine. I have installed and configured MYSQL Problem : I cannot log into MYSQL database either from root or user.(local host) The error is 2002: unable to connect to local host thru socket "varlibmysoc" but cannot locate the mysql.sock in /tmp And the service is sqldb is also not working and cannot locate in services.
View Replies !
MySQL Config On Windows98se
I have installed MySQL on Windows98se twice under different paths, and then deleted the second installation. When i run MySQL as usual using the line "C:Program Files uspheremysqlinmysqld-opt.exe" , i get the following error msg: C:Program Files uspheremysqlinmysqld-opt.exe: Fatal error: Can't find messagefile 'C:Program Files usphere2mysqlshareenglisherrmsg.sys' notice that it runs from "nusphere" but tries to find the errmsg.sys file under the other folder "nuspehere2" which i have deleted. I tried looking for a config file so that i can force MySQL to look in the proper "nusphere" path, but i could not find any. I have also tried to look for an entry in the registry but came out with nothing aswell. Have I missed something? Any ideas on how to solve this?
View Replies !
MySQL Config File
I see that there are several MySQL configuration files on my machine: Quote: /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf How do I know which one my install is using?
View Replies !
MySQL Config Not Running
i'm trying to set up MySQL with IIS 7.0 on Windows Vista Home Premium. After you install MySQL, there's a check box to launch the config app. if i leave it checked, the app does not load. if i try to run the app by double-clicking its icon it gives me an error saying, "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail." I cannot find the application event log, though.
View Replies !
MySQL Config Error
I have been tasked to create a CMS for a website, however first I must install it locally to my laptop. I have chosen Joomla! as my CMS, and I understand that in order to run that I must first install Apache, MySQL, and PHP (in that order). Apache installed fine, as did MySQL (the most recent version), however, it will not let me configure it or run the config tool at the end of the installation, citing the message: "the side-by-side configuration is incorrect." Does anybody have any idea why this keeps happening and what I can do to resolve it?
View Replies !
Server Instance Config
After installing MySQL 4.1.13a, Server Instance Config Wizard runs. At the end of the wizard it wants to execute, to finalize the configuration. Though once it gets to the point of executing the Service. It fails.
View Replies !
Problems Running With Instance Config Wizard
I can't seem to run the Instance Config Wizard for MySQL 5.0 on my computer. I am running windows Vista and each time I attempt to run the Wizard it responds with a dialog box: "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more details." How do I resolve this issue?
View Replies !
Config Mysql For Huge Data But Single User
I´m new to mysql and want to know how I set up the my.ini for best performance. I´m running a PC with dual core and 3GB RAM, Windows XP, XAMPP I want to configure mysql for best performance for a singele user acess. I just want to do some sql-query on a huge database (25GB) - only one query at once. At the moment my query nedds about two hours....
View Replies !
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 !
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 !
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 !
LIKE '[0-9]%' Not Working
Here is the SQL query: Code: SELECT * FROM member WHERE username LIKE '[0-9]%' Returns 0 rows. I've tried this on 4.1.7-nt as well as 4.0.22-standard; neither work. And yes, there are records in the table that should match that pattern.
View Replies !
LIKE '%$var%' Not Working
I am trying to create an sql statement to return values on either side of the variable. Code: $sql = "SELECT * FROM principals LIKE companyName = '%{$_POST['companyName']}%'"; The error was: Error: 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 'LIKE companyName = '%Mike%'' at line 1
View Replies !
Not Working
I have 4.1.10a on my local machine and the following WHERE clause works fine: Code: WHERE wk1 IN (select max(wk1) from wkpts where teamid = w.teamid) But when I upload it to my web site, I get an sytax error at 'select max(wk1) from...' My web host has MySQL version 4.0.20-standard. Can someone tell me why it would work locally, but not on my web host's server? Thank you.
View Replies !
!= Not Working?
SELECT d.cache_diff, d.cache_name, d.cache_type, d.cache_last_found FROM geocaches d LEFT JOIN logvisit ON d.cache_id=logvisit.cache_id WHERE d.cache_status = 0 && logvisit.log_type != 'Found' && logvisit.log_owner_id = 64 This returns zero rows. Its true that records in logvisit.log_type for this user are only FOUND but I am trying to display cache information for all other caches (in geocaches table) that the user did not log FOUND in logvisit. So, basically if the user logged against 3 caches and there are 10 caches available to log agains then I want to display only the remaining 7. Is JOIN the way to go on this one?
View Replies !
Working With 'SET'
I would like to know how I can work with a PHP Array and a set. How can i get all rows where a set where at least one item oft the php Array is inside the set column?
View Replies !
Mysql Not Working
im trying to install bugzilla (im on rh9) ive gotto the point where you run ./checksetup.PL. Thing is its saying it cant connect to the database - but the database is there and the settings n the config files are right.
View Replies !
Datetime Not Working
I am trying to add a date that a blog post was posted. However, the date is not changing.. it is remaining as 0000-00-00 00:00:00 This is my code: PHP Code:  $sql = "insert into entries (id, cat_id, dateposted, subject, body) values ('$_POST[id]', '$_POST[cat_id]', '$_POST[dateposted]', '$_POST[subject]', '$_POST[body]')"; mysql_query($sql); I have a feeling it is something to do with the $_POST[dateposted] as there is not actually a field in my form for dateposted
View Replies !
Why Isn't Load_file() Working
Today I learned how you're supposed to put pictures and other binary data into databases. Problem is, no matter if I use load_file('pic.jpg') or a script-side method, the value in the db ends up NULL. Why is this? I've verified it is null by running the "is null" statement. I have the picture in the same folder as the /bin dir, so the command "insert into... pic=load_file('pic.jpg') sholud work. Can anyone tell me why it's not? This doesn't just happen with pictures btw. Why won't it import? I'm doing this as root user, by the way.
View Replies !
ORDER BY Not Working?
I have a users table with first name and last name as well as several other entries. I also have a table for permissions called user_levels. For some reason, I can't get ORDER BY to return results in alphabetical order by last name. Here's the query: Code: SELECT * FROM users u LEFT JOIN user_levels ul ON u.level_id = ul.level_id ORDER BY 'u.last' Is there any reason this shouldn't work? I've done this a dozen times for other projects and never had a problem. I'm wondering if I'm code-fried and/or too close to see it
View Replies !
Rand() Not Working In Php?
I'm trying to get the rand from the mysql. When I use the MySQL Front software (SELECT * FROM keyword ORDER BY RAND() LIMIT 2, it gives me random which is working fine. But when I use the php and it doesn't give me random. What wrong with php? $query = "SELECT * FROM keyword ORDER BY rand() LIMIT 2"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); echo "<PRE>"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print_r($line); } echo "</pre>"; mysql_free_result($result);
View Replies !
|
TRACKER
