[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

MySQL Server

47K

Solutions

23K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello,

I am trying to import a SQL file dumped using MySQL administrator from v5.5.12, first using MysQL8 on Windows 10 then using 5.6.41 on AWS/RDS, the error using MySQL Workbench 8 is:

15:25:12 Restoring C:\path\sql\sqlfile.sql
Running: mysql.exe --defaults-file="c:\users\users\appdata\local\temp\tmpyzknop.cnf"  --protocol=tcp --host=awsendpoint.rds.amazonaws.com --user=myuser --port=3306 --default-character-set=utf8 --comments --database=mysql  < "C:\\Users\\users\\OneDrive\\Documents\\sqlfile.sql"
ERROR 1044 (42000) at line 21: Access denied for user 'myuser'@'%' to database 'mysql'

Operation failed with exitcode 1
15:25:17 Restoring C:\Users\abell\OneDrive\Documents\\sqlfile.sql
Running: mysql.exe --defaults-file="c:\users\user\appdata\local\temp\tmpvhirjz.cnf"  --protocol=tcp --host=awsendpoint.rds.amazonaws.com --user=myuser --port=3306 --default-character-set=utf8 --comments --database=mysql  < "C:\\Users\\user\\OneDrive\\Documents\\sqlfile.sql"
ERROR 1045 (28000): Access denied for user 'myuser'@'123.456.78.9' (using password: NO)

Operation failed with exitcode 1

I've established that the username and password with which I logged on to AWS.RDS via Workbench is the master user for this instance, BUT I also notice it doesn't have DBS and maintenance perms and I am not sure if these are required or how to set them from AWS dashboard ? or how to create a new user for the existing RDS instance MYSQL as permission is denied using the …
0
OWASP: Threats Fundamentals
LVL 12
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

Hi,

We will undergo a migration from Oracle to MariaDB and as now I found out that there will be column type different in both DB, so comparing column type is not making sense at all, usually AFTER migration from Oracle 10gR2/12c to MariaDB 10.3.x, what is the best way to compare and make sure that the migration is ok?
0
Hi EE,

What's the reason behind the following error (see attached) I am getting mixed results when I google it, I am current the local admin on my PC and when I change port numbers in the .ini file (attached) xampp just tries to pick random ones.

Attached is the log file as well no clues I can see here.

Any assistance is welcome.


Thank you.
error.PNG
my.ini
mysql_error.log
0
I want make a display Candy name only display icon tick in the column Candy without duplicate in column melvin and angel . But right now my data is duplicate over in every name column .
 
question1.JPGThis is my table display right now

      <div class="card mb-3">
        <div class="card-header">
          <i class="fa fa-table"></i> Calendar</div>
        <div class="card-body">
          <div class="table-responsive">
            <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
              <thead>
			  <tr>
			  <th>Time</th>
			  <?php 
			  $namearr = array(); 
			  $sql="select * from admin_staff";
			  $result3= mysqli_query($DBcon,$sql);
			  while ($row3= $result3->fetch_array()){ 
			  ?>
			  <th><?php echo $row3['name']; }?></th>
			  </tr>
			  </thead>
			  <tbody>
			  <?php 
				
				$open_time = strtotime("9:00");
				$close_time = strtotime("21:00");
				
			  for($i=$open_time; $i<$close_time; $i+=3600){
			  ?>
			  <tr>
			  <td><?php echo date("l - H:i",$i); ?></td>

			  <?php 
			  $sql_count="select count(*) as counter from admin_staff";
			  $result_count= mysqli_query($DBcon,$sql_count);
			  $rowcount= mysqli_fetch_assoc($result_count);
			  for($count=1;$count<=$rowcount['counter'];$count++)
			  {
			  ?>
			  <td>
			  <?php 
				$new_time= date("H:i:s",$i);
				
			  	$sql= "select * from admin_calendar where time='$new_time'";
				$result4= mysqli_query($DBcon,$sql);
				$row4= 

Open in new window

0
Hi,
I'm fairly new to php and mysql but I'm creating a PHP and MySQL web application for a client. I have a register.php page with the following form fields:
Contact Name, Phone, Email, Password, Confirm Password, Ticket Holder Password and Ticket Holder Confirm Password, where Users can register/sign up to use the app. Once they do register, they get redirected to admin_login.php page where they can login and get full access to the app and various other pages I've created.

My Problem:
My Password validation functions aren't working and I'm not sure why. I want the passwords to be a minimum of 8 characters, contain one upper and lowercase letter, a number and a special character. I'm using a regular expressions code that I found online. What I want is to validate the Password fields, so if the User enters a password that meets the criteria mentioned above than it should INSERT the data INTO the database, if it doesn't meet the Password criteria mentioned above I want to display an error message saying: "Password must be minimum of 8 characters, contain one upper and lowercase letter, a  number and a special character". I'm new to using php functions and how to call them properly.

This is the code in my functions.php page:

<?php

// FUNCTIONS.php

// clean the form data to prevent injections

/* Built in functions used:
   trim()
   stripcslashes()
   htmlspecialchars()
   strip_tags()
   str_replace()
*/

function validateFormData($formData) {

Open in new window

0
I have a VBA frontend system which connects to a mysql backend.

It authenticates on manually created mysql users which are setup to allow access to further databases once authenticated.

I need to investigate offering users to ability to change their own mysql password without having an admin having to do it at command line level.

Obviously im consious of security and need to get some ideas on how to acheive this.

thanks
0
Hi,
I have created the following table-
CREATE TABLE rbl_kyc_profile (
      userid int8 NOT NULL,
      kyctype varchar(50) NOT NULL,
      effectivekycstatus varchar(50) NOT NULL,
      validfrom timestamp NULL,
      validtill timestamp NULL,
      authtype varchar(50) NULL,
      ovdnumber varchar(50) NULL,
      attrs jsonb NULL,
      name varchar(100) NULL
);
Many places i have seen an extra column id in the table.
Do i need to do that in this table ??
what are the pros and cons of it ?

Thanks
0
In below scenerio, how mysql master- master replication can be used?

3 local xampp servers in different location
1 live server
0
Hello

I have setup MySQL 4.6.x on AWS, and created a new DB schema to receive data from a SQL file created using MySQL DUMP.  Using MySQL Workbench 8.0 CE I can establish a connection, but when I import the data (it seems to start with password-yes then switch to password-no after first failure exit code 1) I get the following error:

ERROR 1044 (42000) at line 21: Access denied for user 'admin'@'%' to database 'mysql'

If it is relevant the SQL file was dumped with a different admin account/password on a different SQL box.

I've looked at a lot of articles and believe this is related to logins/perms but I am mostly good with data rather than sysadmin so any help getting started greatly appreciated...

The full error text is..

box1.ap-southeast-1.rds.amazonaws.com
14:26:34 Restoring C:\Program Files\MySQL\MySQL Server 8.0\bin\yfsql.sql
Running: mysql.exe --defaults-file="c:\users\user\appdata\local\temp\tmpgq7exl.cnf"  --protocol=tcp --host=box1.ap-southeast-1.rds.amazonaws.com --user=admin --port=3306 --default-character-set=utf8 --comments  < "C:\\Program Files\\MySQL\\MySQL Server 8.0\\bin\\sql.sql"
ERROR 1044 (42000) at line 21: Access denied for user 'admin'@'%' to database 'mysql'

Operation failed with exitcode 1
14:26:55 Restoring C:\Program Files\MySQL\MySQL Server 8.0\bin\yfsql.sql
Running: mysql.exe --defaults-file="c:\users\user\appdata\local\temp\tmpjzz_nr.cnf"  --protocol=tcp --host=box1.ap-southeast-1.rds.amazonaws.com --user=admin
0
on my production system I am running RedHat Linux (2.6.18-53.el5xen GNU/Linux) and running Mysql 5.0.45 and PHP version 5.1.6 .  I am upgrading the system but I am coming across an issue.  I have loaded RedHat 2.6.32-754.el6.x86_64 GNU/Linux and with MySql 5.1.73 on another system and running PHP 5.3.3.  The problem I am having is in my PHP.ini file it is not loading the Mysql.so module.  In the install there is no Mysql.so module.  So now my php applications are not running.  Please help me resolve this issue.
0
Exploring SharePoint 2016
LVL 12
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

OK so we have an in house marketing database that used to connect to a remote MySQL database on a Linux server. I decided to migrate to a MySQL server on our in house computer that also serves as the domain controller. everything is working fine except when I try to export a CVS. This was all operational when it was connecting to the Linux server prior. Please give me a hand guys!

The error that I am getting is below:
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at …
0
when we use exists in a query

what is meaning of select x means

select count(order_nr) from xyz where ord_cd="10"
exists(

select 'x' from ABC a where ef=ge
and
a.some_cd='zz'
and
((datediff(...)or (datediff.....))


i checked below link
https://www.geeksforgeeks.org/sql-exists/

how to validate my results are correct or not

how to break above query to see if difference of time is actually correct?
please advise
0
We are having an issue with a MYSQL database issue.  We created a front end in MS access that interfaces with a MYSQL data base.  The access tool works on multiple PCs throughout the organization except for a couple. When Installed on specific laptops the database kick back a credentials error that says: "Login Failures for the entered credentials.  (1 of 3 tries)"

We have installed the database on other computers and she can log in with those same credentials that kick back the error on her laptop so we don't beleive there is an issue with end users credentials in MySQL workbench.

"Login Failures for the entered credentials.  (1 of 3 tries)"
0
Hello,

this morning I got below MySQL DB error. It seems as a temporary error, but in order to avoid any possible future problems, I need your suggestions on below error.

I am herewith attaching error log for more details.

Workflow Manager Exception : PersistenceException - org.hibernate.exception.GenericJDBCException: Could not open connection
mysqld.log
0
I need to delete a block of text that is on 400 pages of my mysql db.  It is in wp_posts and the post_content section.

This is the block of code
<p><span class="heading">Product Label</span> - <span style="color: #909;"> Place your mouse cursor over the image to zoom in to read the label. </span></p> <p><img src="/Resources/labels/3538.jpg" alt="Product Label" /><br /><br /></p> 

Open in new window


This block is the same for all pages with the exception of the number specifying the .jpg

This is the sql I created but it isn't working even without the regex.

SELECT * FROM `wp_posts` WHERE (post_content LIKE '%<p><span class="heading">Product Label</span> - <span style="color: #909;"> Place your mouse cursor over the image to zoom in to read the label. </span></p> <p><img src="/Resources/labels/3538.jpg" alt="Product Label" /><br /><br /></p>%'); 

Open in new window


Please help me to create a query that will work for all numbered jpg's and just remove the block and replace it with nothing.

Thanks,
0
All,
I need to create a MySQL query that will be run through pHp.
I have 2 tables Record & Donations. The only field they have in common is the "email" field.
The Donations table has fullname, email, donation amount, donation date and year (yyyy).
The Record table has fname, lname, add1, add2, city, state, zip and email.

I would like results:
Want a listing of all the emails from everyone who has ever given, but NOT to include current donations for next year.
The search should examine both tables and remove any duplicate emails.

The 1st part is easy -
SELECT email FROM Donations WHERE  year <> '2019'  ORDER BY `email` asc;

I can get a listing of all the emails in Record that don't have a match anywhere in Donations by using

Select email FROM Record WHERE NOT EXISTS (SELECT email FROM donations WHERE Donations.email =  Records.email)  ORDER BY `email` asc;

But I'm not sure that is exactly the right statement and I don't know how to combine the 2 parts.

Any assistance would be appreciated.

Thanks,
Russ
0
Dear Experts

I have a question about python and mysql interaction. I have big table which contains column named DATETEXT, which simply contains full datetime in text format, like "Fri, 09 Aug 2013 18:46:10 +0200", I need to convert it to datetime value which is not a problem, but I need to update another column in the same table with this value.

So my question is how to update one columns in table X based on value of another column in table X.

Many thanks

Vladimir
0
How to write below query on say table ORDER given the order_nbr is the column name in that table

queries to find below
1. order number more than 11 digits
2. order number more than 11 digits which has payment online
3. order number more than 18 digits
4. order number more than 18 digits which has payment CreditCard option

Please advise
0
Description of issue:
  • We are attempting to migrate data and continue to replicate from our local MYSQL database to Aurora MySQL. Aurora is reporting that we have successfully completed a migration however when we check the data not all the records have migrated after a certain point. After this point no more of the original records are copied however the database continues to replicate changes after the initial full load. Leaving a gap of missing records.
  • This problem only occurs with tables with BLOB fields. Even though tables with BLOB fields do not full load all records the task reports 100% completion and no tables errored.
  • As stated replication continues as normal afterwards and new rows are inserted.
  • Approx 350,000 records are missing
  • Full LOB mode is enabled with default chunk size of 64.
  • We have set max_allowed_packet and wait_timeout on the target to their maximum values 1073741824 and 31536000 respectively.
  • We also reduced the commit rate during full load to 1000. We found that the default values for these would cause the full load to fail and continually restart.

Source: On site MySQL 5.7.20 Community over VPN
Target: Aurora MySQL 5.7.12 db.r4.large
Replication instance: dms.r4.large, version 3.1.2, 80GB storage
Migration type: Full Load, Ongoing Replication
Network transfer: Over VPN to the VPC
Size of transfer: ~700 tables totalling nearly 50GB
 
Example:
0
IT Pros Agree: AI and Machine Learning Key
LVL 1
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

hi,

I am considering how to HA to maxscale for MariaDB as maxscale is the SPOF, and I am suggested to use Pacemaker, Keepalived and/OR Heartbeat, how can those component fit into the maxscale and MariaDB cluster DB environment ?

any topology diagram for it?

which one is better in terms of stability ?
0
Hi,I'm having trouble trying to change the bootstrap .active class state via jquery.I've googled and found several solutions but none of them are working for me.Here is my html code:

[code]<section id="hero">
   			<div class="container-fluid">
               <div class="container">
				   <div class="row">
						<div class="col-md-12">
							<nav class="navbar navbar-toggleable-md navbar-light">
							  <button class="navbar-toggler navbar-toggler-right" type="button" data-toggle="collapse" data-target="#navbarNavDropdown2" aria-controls="navbarNavDropdown2" aria-expanded="false" aria-label="Toggle navigation">
								  <span class="navbar-toggler-icon"></span>
								  <span class="fas fa-times hide" data-wow-delay="2s"></span>
							  </button>
							  <a class="navbar-brand logo" href="index.php"></a>
							  <div class="collapse navbar-collapse" id="navbarNavDropdown2">
								<ul class="navbar-nav ml-auto">
								  <li class="nav-item active">
									<a class="nav-link" href="index.php">Home <span class="sr-only">(current)</span></a>
								  </li>
								  <li class="nav-item">
									<a class="nav-link" href="about.php">About Us</a>
								  </li>
								  <li class="nav-item">
									<a class="nav-link" href="howitworks.php">How it Works</a>
								  </li>
								  <?php
								  if( $_SESSION['loggedInUser'] ) { // if user is logged in
								  ?>
							      <li class="nav-item dropdown">
									<a class="nav-link" 

Open in new window

1
Hi,
I'd like to print each one of these tickets on a envelope (#10), so I would like to output a single pdf document with 4 pages, one ticket per page. I don't know if it's possible to print my HTML content on an envelope sized 9.5" x 4.125". If you look at the screenshot attached, you'll see I have all 4 tickets on a single page. I want to create a single PDF document with multiple pages, again one ticket per page.
Here is my code I have so far:
// winning tickets pdf
function fetch_data() {  
      $output = '';
      $userID = ($_SESSION["loggedInUserID"]);
      //$conn = mysqli_connect("localhost", "lormar5_wo693", "sDieYQb752KZc!;", "lormar5_wo693");  connection to theme
      $conn = mysqli_connect("localhost", "root", "root", "db_hockeypoolfundraiser");
	  $sql = "SELECT * FROM participants LIMIT 1";  
      $result = mysqli_query($conn, $sql);  
      while($row = mysqli_fetch_array($result))  
      {       
      $output .= '<tr>
	  			<td style="border-bottom: 1px solid #dfdfe0;">
				<br><br><strong>Winners Name:</strong> '.$_SESSION["participantName"].'
				<br><br><strong>First Goal Time:</strong> '.$_SESSION["firstGoalTime"].'
				<br><br><strong>Game Date:</strong> '.$_SESSION["gameDate"].' <br><br>
				</td>
				
				<td style="border-bottom: 1px solid #dfdfe0;">
				<br><br><strong>Phone:</strong> '.$_SESSION["participantPhone"].'
				<br><br><strong>Amount:</strong> $'.$_SESSION["priceFirstGoal"].'
				<br><br><strong>Player:</strong> 

Open in new window

0
I have a form/page that I'm using to book in stock based on a poNumber that generates the stock items linked to that poNumber/supplier. Currently for each line (there may be 10 items for example on order) the user needs to add qty rec'd, qty outstanding, receipted by and delivery note number in the form for each line.

I want to short cut some of the data entry by having a single entry for receipted by and delivery note number but for this to populate the rows for each entry once submitted.

The code I have at the moment is as follows: -

<div class="container">	
	<form class="form" method="post" action="transit_temp.php">	
	
	<?php
	
	$poNumber = isset($_POST['poNumber']) ? $_POST['poNumber'] : false;
	
	$poNumber = $mysqli->real_escape_string($poNumber);
	
	$index=0;

	$query = 'SELECT * FROM goodsInTrans WHERE poNumber = "'.$poNumber.'"';
			
				if (!$result = $mysqli->query($query)) {
				$err
				= "QUERY FAIL: "
				. $query
				. ' ERRNO: '
				. $mysqli->errno
				. ' ERROR: '
				. $mysqli->error
				;
				trigger_error($err, E_USER_ERROR);
				}		
	
				while ($row = $result->fetch_object())
				
				{ 

				?>
					<div class="form-group row">
						<div class=""><input type="hidden" 				class="form-control" 	name="data[<?php echo $index; ?>][supplier]" 			value="<?php echo $row->supplier ?>"/></div>
						<div class="col-xs-3"><input type="text" 		class="form-control" 	name="data[<?php echo $index; ?>][sku]"	 				value="<?php echo $row->sku 

Open in new window

0
Hello Experts


Need help with code 1064.

mysql> CREATE TABLE BankOfItaly(name char(20) NOT NULL, email varchar(20) NOT NULL, MonetaryValue float(7,2) NOT NULL, Phone int(10) NOT NULL PRIMARY KEY(name));

Open in new window


I have checked over the syntax yet, when creating a new database with an associated table this error occurs. How do I create tables successfully so this error does not occur anymore? The error is issue with assigning the Primary Key to (name))
0
I need to search for an order in my WooCommerce back office by email address.  I can see the email address in wp_users but don't know how to put a name to the email address.  Is there a plugin or mysql code that will accomplish that?

Thanks,
0

MySQL Server

47K

Solutions

23K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.